Sponsored Link

Sponsored Link

Monday, September 15, 2008

Filter by Color

MS Excel has come with great features like Filter by color is just one them.
1. Applicable in Office 2007
2. After you apply conditional formatting from the home Icon.
3. Apply filter by clicking on Filter under the Data icon.
4. Click Filter Cell (which is A1 in this case)
5. Go to filter by color option from drop down.
6. Select the color using which you want to filter.


Also, do let me know your comments about this post and subscribe to us to receive latest updates via email

We assure you knowledge, not SPAM!


Dr Pankaj said...

Thanks Dear this really helps in coding the data in colour formate. And presenting it in a much better way

Post a Comment