You probably know how easy it is to add or remove the Grand Totals in a pivot table, by using the Ribbon commands.
But keep reading, to see an even quicker way!
Grand Totals on the Ribbon
Yes, it’s easy to change the Grand Total settings on the Ribbon:
- Select any cell in the pivot table
- On the Ribbon, under PivotTable Tools, click the Design tab
- In the Layout group, at the left, click Grand Totals
- Click one of the options.
Quickly Remove Grand Totals
For an even quicker way to remove Grand Totals, follow these steps:
- In the pivot table, right-click the Grand Total label cell (not the total amounts) – either the Row Grand Total or the Column Grand Total
- In the popup menu, click Remove Grand Total
That’s it! Unfortunately, there’s no equally quick way to add Grand Totals, but maybe that feature will be in the next version of Excel.
________