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.
-
Select a cell in the range that contains subtotals.
-
On the Data tab, in the Outline group, click Subtotal.
The Subtotal dialog box is displayed.
-
Click Remove All.
Remove subtotals from a PivotTable
-
In a PivotTable, select an item of a row or column field.
This displays the PivotTable Tools, adding the PivotTable Analyze and Design tabs.
-
On the PivotTable Analyze tab, in the Active Field group, click Field Settings.
-
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.