» Copying the Subtotals Summary in Excel 2007
CATEGORY - Excel Subtotals
VERSION - Microsoft Excel 2007
1. Add subtotals to the List.
2. In the Subtotal levels, click level 2.
3. Select a cell in the List, and press Ctrl+Shift+* or press Ctrl+A.
4. Press Alt+; to select visible cells only.
Or
Select Home -> Find & Select (in Editing tab) -> Go To Special -> Visible cells only.
Or
Press F5 -> Special -> Visible cells only.
5. Copy and paste the subtotals summary to a different sheet.
Book Store:
Recommended Books:
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Financial Statement Analysis with S&P insert card
- Mortgages For Dummies®
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
No comments have been submitted.

