» Coloring Visible Rows in Filtered List in Excel 2007
CATEGORY - Excel Filter
VERSION - Microsoft Excel 2007
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:
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- How to Pay Zero Taxes (Annual)
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Microsoft Office XP Introductory Concepts and Techniques
- Financial Peace: Revisited
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
No comments have been submitted.
