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.

  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.