Show All

Hide All

When you remove subtotals, Microsoft Office 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.

1. Click a cell in the list that contains a subtotal.
2. On the Data tab, in the Outline group, click Subtotal.

   The Subtotal dialog box is displayed.

3. Click Remove All.