Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | How to sort Excel sheet according to font color
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

How to sort Excel sheet according to font color

Microsoft Excel allows you to sort your data in a number of different and custom ways, let's learn how to sort Excel data according to the color of the fonts.

 
  Author: mat | Version: 2012 | 9th September 2013 |  
 
 
1.
 

Select the sheet data that has different font colors in its cells.




Also recommended:


 
 
2.
 

In the Toolbar above, while Home tab being active, click Sort & Filter and choose Custom Sort...

 
 
3.
 

Choose the Column you want to sort your data by ...

The one with different colored fonts.

 
 
4.
 

... choose Font Color for the Sort On option ...

 
 
5.
 

... choose the font color you want to sort by first and click OK.

 
 
6.
 

That's it, your Excel data should now be sorted by the font colors.




Also recommended:

 
 
 
   
  Please login to post a comment
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO