» Copying or Applying Color to Groups and Outlines
CATEGORY - Excel Grouping and Outlining
VERSION - All Microsoft Excel Versions
1. Create the summary report using Group and Outline.
2. Select any cell in the List, and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A) to select the List.
3. Press Alt+; to select the visible cells.
4. Copy and paste the data into a different sheet.
OR
Apply color to the visible cells by selecting a color from the Fill Color icon on the Formatting toolbar.
Book Store:
Recommended Books:
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Microsoft Office XP Step-By-Step (With CD-ROM)
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
No comments have been submitted.
