When you insert an Excel Pivot Table and drop a field in the Row/Column Labels you will automatically get a Grand Total.

How about if you want to remove this Grand Total or show it only for a row or column?

Well you have that flexibility and this is how…


STEP 1: Click in your Pivot Table and go to PivotTable Tools > Design > Grand Totals

STEP 2: Choose any of the options below:

off for rows & columns

Off for rows & columns pivot

On for rows & columns

On for rows & columns pivot

on for rows

on for rows pivot

on for columns

on for columns pivot

SHORTCUT TIP: You can also remove a Grand Total by Right Clicking on the Grand Total heading and choosing Remove Grand Total

remove grand total shortcut

Insert Grand Totals



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Refresh a Pivot Table When the information in your data set gets updated you need to Refresh your Pivot Table to see those changes in your Pivot Table.  There are three ways to do this.  First click on your Pivot Table and: 1. From the Ribbon choose: PivotTable Tools > Options > Refresh 2....
Lock the Excel Pivot Table but not the Slicer Sometimes when you are sharing an Excel Pivot Table with your colleagues you do not want the other user(s) to mess with your Pivot Table layout and format. What you can do is lock the Pivot Table and only allow the user(s) to select the Slicers, making your report interact...
5 Speedy Steps To An Excel Pivot Table! (infograph... G'day All, In this free downloadable Excel Pivot Table Cheat Sheet/Infographic, I show you how easy it is to create an Excel Pivot Table in 5 Speedy Steps...Enjoy and please comment below if you have any Excel or Pivot Table questions, I'm here to help you 🙂 DOWNLOAD ...
Sorting a Pivot Table There are a few ways that you can Sort a Pivot Table.  You can Sort the Row/Column Labels as well as Values within a Pivot Table.  Below I show you three quick ways... DOWNLOAD WORKBOOK Helpful Resource: