» 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:
- Excel 2002 For Dummies®
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Special Edition Using Microsoft Outlook 2002
- Analyzing Markets, Products, and Marketing Plans
- The New Financial Order: Risk in the Twenty-First Century
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
No comments have been submitted.
