Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Sort Data by Font Color in Microsoft Excel

Date:2019-8-29 Author:Olivia

When editing a worksheet, sometimes you might change the color of the font to make the it much readable. And in some cases, like analyzing monthly sales data, you need to sort data by font color in Excel, which could help to understand your data better, quickly find what you want and make more effective decisions.

1. First, select one cell with non-default color, go to Data tab and click Sort in Sort & Filter group. The Sort dialog box will display.

How to Sort Data by Font Color in Microsoft Excel

2. Sort by the specified column, Sort on Font Color (you can also sort on Cell Color and Cell Icon), select the color bar which you want to sort data by, and there are types – On Top or On Bottom for your choice. Simply hit OK.

How to Sort Data by Font Color in Microsoft Excel

3. Select On Top when you want all the colored font at the top of the dataset.

How to Sort Data by Font Color in Microsoft Excel

4. Select On Bottom when you want all the colored font at the bottom of the dataset.

How to Sort Data by Font Color in Microsoft Excel

How to Sort Data by Font Color in Microsoft Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *