Data Presentation Products   Microsoft Excel Subtotals     Microsoft Excel Add-ins

HOME PRODUCTS EZ-Format EZ-Subtotal EZ-Split EZ-Stat EZ-Calc EZ-Chart EZ-Chart2 EZ-Pivot Xcelerator EZ-Quick EZ-GP All Products MOVIES DOWNLOADS EZ-Format EZ-Subtotal EZ-Split EZ-Stat EZ-Calc EZ-Chart EZ-Chart2 EZ-Pivot Xcelerator EZ-Quick EZ-GP All Products PURCHASE EZ-Format EZ-Subtotal EZ-Split EZ-Stat EZ-Calc EZ-Chart EZ-Chart2 EZ-Pivot Xcelerator EZ-Quick EZ-GP All Products CONTACT US MORE FAQ Support Site Map About Us

HOME > PRODUCTS > EZ-SUBTOTAL > Worksheet Examples EZ-SUBTOTAL | FEATURES | INTERFACE | EXAMPLES | Ranking | VIDEOS | FREE-FEATURES

Subtotal Ranking | Subtotal Sorting Resort Subtotaled Excel Data by the Subtotal Amounts of any Subtotaled Field Resorting Subtotaled Excel Data Using EZ-Subtotal EZ-Subtotal Created Subtotals for State and City Subtotaled Data Resorted by Sales Amount Subtotals States are Automatically Resorted in Descending Order by the Sales Amount Subtotals Use the Subtotal Dialog Shown Below to Set the Ranking Field Start with an Excel List with Column Totals for the Fields to Subtotaled Column Totals are optional, however EZ-Subtotal automatically subtotals columns with column totals and removes the Column Total row. Subtotal the Excel List Click the "Sigma" icon, Select "Subtotals", select the Break Fields, check "Break Fields Left" and "Default AutoFilter On" and click "OK". Select the Subtotaled Field to Rank / Resort By Click the "Sigma" icon, Select "Subtotals", open "Field for Ranking All Breaks" and select a Field, optionally check "Rank Descending" and click "OK". Subtotaled Data is Immediately Resorted or Ranked Use the "L" icon's Menu to View the City & Above Subtotals EZ-Subtotal Ranked Subtotals for City & Above Use the "L" icon's Menu to Temporarily Turn Ranking Off and On Permanently Remove Ranking Click the "Sigma" icon, Select "Subtotals", open "Field for Ranking ...", select "None", and click "OK". Try EZ-Subtotal New Version 06/19/10 Experience how to quickly create and use better formatted Excel Subtotals! Installs and Completely Uninstalls in Seconds - Become an EZ-Subtotal Expert in Minutes. Securely Purchase from within Excel for $29.95 and EZ-Subtotal Automatically Self-Registers. Includes Life Time Free Updates and Upgrades - Simply Download & Install the Latest Version. More Information on Making & Using Better Excel Subtotals EZ-SUBTOTAL | FEATURES | INTERFACE | EXAMPLES | Ranking | VIDEOS | FREE-FEATURES

DPPI Add-ins for Excel are Windows Vista®, Windows 7® and Microsoft® Office 2007/2010 Compatible HOME PRODUCTS DOWNLOADS PURCHASE MOVIES FAQ SUPPORT CONTACT US ABOUT SITEMAP COPYRIGHT © 2002-2010, Data Presentation Products, Inc., ALL RIGHTS RESERVED Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.