Remove subtotals from a PivotTable

Applies To
Excel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016

In a PivotTable, subtotals are calculated automatically and appear by default. Here’s how to hide them:

  1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.
    PivotTable Tools
  2. Click Design > Subtotals, and then pick Do Not Show Subtotals.

Subtotals button on the Design tab

More about PivotTables