Remove subtotals

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 menu, click Subtotals.
  3. Click Remove All.
Applies to:
Excel 2003