Remove subtotals

What do you want to do?


Watch a video

Top of Page Top of Page

Remove subtotals

When you remove subtotals, Microsoft Office Excel also removes the outline (outline: Worksheet data in which rows or columns of detail data are grouped so that you can create summary reports. The outline can summarize either an entire worksheet or a selected portion of it.) 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.

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

The Subtotal dialog box is displayed.

  1. Click Remove All.

Top of Page Top of Page

Remove subtotals from a PivotTable

  1. In a PivotTable, select an item (item: A subcategory of a field in PivotTable and PivotChart reports. For instance, the field "Month" could have items such as "January," "February," and so on.) of a row or column field.

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

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

Excel Ribbon Image

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

Note    If a field contains a calculated item (calculated item: An item within a PivotTable field or PivotChart field that uses a formula you create. Calculated items can perform calculations by using the contents of other items within the same field of the PivotTable report or PivotChart report.), you can't change the subtotal summary function.

Top of Page Top of Page

 
 
Applies to:
Excel 2010, Excel 2007