Dummy Essentials
A complete source of effective solutions to all your computer problems in simplified manner.

Sort By Color In MS Excel 2007

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).
3 comments:

I love this feature of MS Excel 2007. Now you need not set specific parameters to sort. Keep coloring and keep sorting.


@Ezra
That's true, it makes things simple :)


Post a Comment

Search Dummy Essentials Here:






Visitor's Review

We would appreciate you taking out a little more of your time to rate our blog. It would help us to improve and encourage us to share whatever we get to learn in the process. Thanks!
Bookmark and Share

 Subscribe To Dummy Essentials

Enter Your Email Address & Click On Go:

  
Delivered by FeedBurner

Translate Dummy Essentials

Google-Translate-Chinese (Simplified) BETA Google-Translate-English to French Google-Translate-English to German Google-Translate-English to Italian Google-Translate-English to Japanese BETA Google-Translate-English to Korean BETA Google-Translate-English to Russian BETA Google-Translate-English to Spanish
Powered by Google

Dummy Essentials Visits