Excel can sort by cell color, font color, and cell icon. First, you must you must define the colors for your sort columns/fields. For this example, we’ll select colors based on the SALES column.

But if you can manage the data by field (column)—for example ... the database using that macro. Many Excel users misunderstand the program’s sorting and filtering processes.

In this example, the sheet will be filtered by ... rows where every bit of data meets the parameters. How to sort filtered data in Excel 2. Click on "Data" in the top toolbar.