Today we will explain how you can sort out data in Microsoft Excel 2007 with the use of colors. Not only does this technique organize your sheet but it also helps in easy access to data. Let's learn how, with an example here. Consider the data of the following team members, as shown in the figure.
Now let us put up colors on the names as shown below:
Next, if we need some specific color that we wish to sort out, this is how we go about it.
After you apply the filters on your data, Click to sort as shown here:
Choose "Filter by color" and select the color you wish to sort from the list.
Once, you select your color, click on “OK”. And you are done.
As you see above that the data has got sorted by the color we selected (in this case, Yellow).
Now let us put up colors on the names as shown below:
Next, if we need some specific color that we wish to sort out, this is how we go about it.
After you apply the filters on your data, Click to sort as shown here:
Choose "Filter by color" and select the color you wish to sort from the list.
Once, you select your color, click on “OK”. And you are done.
As you see above that the data has got sorted by the color we selected (in this case, Yellow).
January 11, 2010 at 6:37 PM
I love this feature of MS Excel 2007. Now you need not set specific parameters to sort. Keep coloring and keep sorting.
January 11, 2010 at 8:07 PM
@Ezra
That's true, it makes things simple :)
January 13, 2010 at 10:06 AM
Wow.. Thanks for the great tip