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.
Note: If you're using Excel 2013 or earlier versions, you'll see the Options and Design tabs.
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.
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.