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.
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.