» Show/Hide Grand Totals in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
To change the default of showing grand totals for rows or columns: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 New Financial Order: Risk in the Twenty-First Century
- Microsoft Access Version 2002 Step by Step
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Dictionary of Finance and Investment Terms
No comments have been submitted.
