Remove Grand Total in a PivotTable

This post will guide you how to remove grand total from pivot table in excel 2013/2016. How do I remove column grand totals and row grand total in a pivot table in excel. How to hide grand total in an excel pivot table.

Remove Grand Total


When you created an excel Pivot Table, the grand total will be added automatically by default. So if you do not need the grand total, just follow below steps to remove it:

#1 select one cell in your pivot table

remove grand total1

#2 go to DESIGN tab from the toolbar at the top of the screen, click Grand Totals command under Layout group and select Off for Rows and Columns from the popup menu list.

remove grand total2

Note:

  • if you only want to remove column grand total, just select On for Columns Only from the popup menu.

remove grand total5

  • if you only want to remove or hide row grand total, just select On for Row Only from the popup menu.

remove grand total4

#3 you will see that both row and column grand total are removed.

remove grand total3

Leave a Reply