Tip Printed from ExcelTip.com

---

Quickly Removing Subtotals in Excel 2007


To quickly remove subtotals:

1. Select any cell in the List and click Sort A To Z or Sort Z to A.
2. In the dialog message box click OK.

To remove subtotals by using the Subtotals dialog box:

Select Data -> Subtotal (In Outline Group) -> Remove All button.