» Coloring and/or Copying Subtotals from Consolidated Lists Containing Links
CATEGORY - Excel Consolidating
VERSION - All Microsoft Excel Versions
1. In the Subtotal levels, click level 1.
2. Select a cell in the List and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A).
3. Select visible cells, and press Alt+;.
OR
Press F5 and in the Go To dialog box, click Special. In the Go To Special dialog box, select Visible cells only and click OK.
4. Copy and paste the subtotals summary into a different sheet or choose a color from the Fill Color icon in the Formatting toolbar.
Book Store:
Recommended Books:
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Windows XP for Dummies
- Windows XP Annoyances
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Marketing Plans That Work, Targeting Growth and Profitability
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
