Quickly Remove Pivot Table Grand Totals

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.

GrandTotalRemove01

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

GrandTotalRemove02 

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.

________

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.