» Coloring Visible Rows in Filtered List in Excel 2007
CATEGORY - Excel Filter
VERSION - Microsoft Excel 2007
To color filtered List according to a criteria:1. Filter the List according to any criteria.
2. Select a cell in filtered area, press Ctrl+Shift+*
or press Ctrl+A to select the visible filtered rows.
3. Select Home -> Fill Color (in Font Group).
4. Repeat the steps above, change to new criteria and different colors.
Book Store:
Recommended Books:
- Special Edition Using Microsoft Word 2002
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Marketing Management
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Microsoft Excel 2002 Formulas (With CD-ROM)
No comments have been submitted.
