|  

» Quickly Removing Subtotals in Excel 2007

CATEGORY - Excel Subtotals VERSION - Microsoft 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.



Rate This Tip
12 34 5
Rating: 5.00     Views: 3444
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments