Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016

Remove subtotals

When you remove subtotals, Microsoft Office Excel also removes the outline and any page breaks that you inserted into the list along with the subtotals.

  1. Select a cell in the range that contains subtotals.

  2. On the Data tab, in the Outline group, click Subtotal.

    The Subtotal dialog box is displayed.

  3. Click Remove All.

Remove subtotals from a PivotTable

  1. In a PivotTable, select an item of a row or column field.

    This displays the PivotTable Tools, adding the PivotTable Analyze and Design tabs.

  2. On the PivotTable Analyze tab, in the Active Field group, click Field Settings.

  3. In the Field Settings dialog box, under Subtotals, click None.

Note: If a field contains a calculated item, you can't change the subtotal summary function.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.