» 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:
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Microsoft Outlook 2002 for Dummies
- Microsoft Word Version 2002 Inside Out
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Microsoft Windows XP Inside Out
No comments have been submitted.
