» Copying or Applying Color to Groups and Outlines in Excel 2007
CATEGORY - Excel Grouping and Outlining
VERSION - Microsoft Excel 2007
1. Add groups and outlines to a report.
2. Select any cell in the report, click Level 1, and press Ctrl+Shift+* or press Ctrl+A) to select the report.
3. Press Alt+; to select the visible cells.
4. Copy and paste the report into a different sheet.
Or
Apply colors to the visible cells by selecting a color from Home -> Fill Color (in Font Group).
Book Store:
Recommended Books:
- Keys to Reading an Annual Report (Barron's Business Keys)
- Microsoft Windows XP Step by Step (With CD-ROM)
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Business Analysis with Microsoft Excel (2nd Edition)
- Financial Risk Manager Handbook, Second Edition
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
No comments have been submitted.
