Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

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.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×