» 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:
- The One Page Business Plan: Start With a Vision, Build a Company!
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Not-for-Profit Accounting Made Easy
- Special Edition Using Microsoft Access 2002
No comments have been submitted.
