Remove subtotals

What do you want to do?

Watch a video

Remove subtotals

Remove subtotals from a PivotTable

Watch a video

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Top of Page

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. In the PivotTable, select an item of a row or column field.

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

  2. On the Options tab, in the Activate Field group, click Field Settings.

    The Subtotal dialog box is displayed.

  3. Click Remove All.

Top of Page

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 Options and Design tabs.

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

    Excel Ribbon Image

  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.

Top of Page

Applies To: Excel 2007, Excel 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language