Tip Printed from ExcelTip.com

---

Show/Hide Grand Totals in 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).