» 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:
- Financial Modeling - 2nd Edition
- Monte Carlo Methods in Finance
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Finance and Accounting for Nonfinancial Managers
No comments have been submitted.
