» Copying or Applying Color to Groups and Outlines in Excel 2007
CATEGORY - Excel Grouping and Outlining
VERSION - Microsoft Excel 2007
To copy or apply colors to summary totals: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 Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Accounting Principles, with CD, 6th Edition
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Excel 2002 For Dummies®
- Getting to Yes: Negotiating Agreement Without Giving In
No comments have been submitted.
