Excel: How to Remove Grand Total from Pivot Table

Often you may want to remove the grand total row from a pivot table in Excel.

Fortunately this is easy to do by using the Grand Totals button within the Design tab.

The following example shows exactly how to do so.

Example: Remove Grand Total from Excel Pivot Table

Suppose we have the following dataset in Excel that shows the points scored by basketball players on various teams:

Now suppose we insert the following pivot table to summarize the sum of points by team:

By default, Excel creates a Grand Total row that shows the grand total of the points values.

To remove this Grand Total row, first click on any cell in the pivot table.

Then, click the Design tab along the top ribbon and then click the dropdown button titled Grand Totals, then click Off for Rows and Columns:

Excel remove total from pivot table

The Grand Total row will be removed from the pivot table:

Note that within the Grand Totals dropdown menu, you can also choose to display the grand total only for the rows or columns if you’d like.

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

Excel: How to Filter Top 10 Values in Pivot Table
Excel: How to Sort Pivot Table by Grand Total
Excel: How to Calculate the Difference Between Two Pivot Tables

Leave a Reply

Your email address will not be published.