Remove subtotals in a list of data in a worksheet

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.

    Note: If you're using Excel 2013 or earlier versions, you'll see the Options and Design tabs.

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

    Note: If you're using Excel 2013 or earlier versions, on the Options 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.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×