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

Color Scales in a Pivot Table Color Scales are new in Excel 2010 and they highlight the smallest and largest data points within your Pivot Table.It works like a heat map, in that it gives the highest number a shade of color and the lowest number a different shade of color, so your numbers can stand out at...
Group By Month With Excel Pivot Tables Before I was a Pivot Table guru, I had to get individual rows of daily sales and group them into a report showing the monthly sales during the year.Grouping these would take a ton of effort using Formulas:Extracting the month and year from each transactional date; Th...
Filter a Pivot Table by Dates There are an array of different Date filters in a Pivot Table.  You can filter by a particular date range, for example: by this week, next month, next quarter, next year, last year, year to date and the list goes on and on.  This is useful if you want to see what invoices are due...
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 ...