» Show/Hide Grand Totals in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
1. Select a cell in the PivotTable report, right click and select Table Options -> Totals & Filters tab.
2. Clear the check box for Show grand totals for rows or Show grand totals for columns.
To show/hide grand totals:
Select PivotTable Tools Ribbon -> Design tab -> Grand Totals (in Layout Group).
Book Store:
Recommended Books:
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Marketing Plans
- Word 2002: The Complete Reference
- Analysis of Financial Statements
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Absolute Beginner's Guide to Microsoft Excel 2002
No comments have been submitted.
