CATEGORY: Excel Subtotals VERSIONS: All Microsoft Excel Versions

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.

Screenshot // Quickly Removing Subtotals

Rate this tip 1 2 3 4 5   RATING: 3.24   VIEWS: 18981 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Marketing Management H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond Mastering Excel 2000 (for beginner) Investments + S&P Card + Powerweb + StockTrak discount coupon Microsoft Windows XP Inside Out Microsoft Outlook 2002 for Dummies

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books