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.
- Click a cell in the list that contains a subtotal.
- On the
Datatab, in theOutlinegroup, clickSubtotal.The
Subtotaldialog box is displayed. - Click
Remove All.