When you remove subtotals, Microsoft 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.
- Click a cell in the list that contains subtotals.
- On the Data menu, click Subtotals.
- Click Remove All.