Tip Printed from ExcelTip.com

---

Quickly Removing Subtotals


To quickly remove subtotals:

1. Select any cell in the List and click Sort Ascending or Sort Descending.
2. Click OK in the dialog message box.

To remove subtotals by using the Subtotals dialog box:

1. From the Data menu, select Subtotals.
2. Click Remove All.