Data Presentation Products
 
Microsoft Excel Subtotals  
 
Microsoft Excel Add-ins  

   

 
  HOME > PRODUCTS > EZ-SUBTOTAL > Free Features

EZ-SUBTOTAL | FEATURES | INTERFACE | EXAMPLES | RANKING | VIDEOS | Free-Features
 


Six Features are "Free" when you Try EZ-Subtotal

Continue to Use these Features for FREE after the Trial

Free Features Video EZ-Subtotal Free Forever Excel Enhancements Video 04/14/2009 2:38
 

1.  Double-Clicking to Set / Unset Filter Values in Excel Only Subtotals

  Double-Clicking to Set / Unset Filters in Non-Subtotaled Data     

Use the Right-Click Menu to turn "Filter with Double-Click" On and Off

All Appropriate Subtotal Rows are Automatically Exposed when Data Filters are Set by Double-Clicking.
Unlike Excel, EZ-Subtotal does not reposition to the first occurance of the selected Filter Value.


Excel Only Created Excel Subtotals with Filters On and Set to 'Steve Smith' using EZ-Subtotal's Double-Click Feature


Same Data with Filter set from the Excel Filter Drop-Down

Subtotal Rows are typically NOT Exposed when Data Filters are Set using Only Excel.
Because of this Microsoft recommends not using Data Filters with Subtotaled Data.
Another problem!  Excel always repositions to the first occurance of the selected Filter Value.


Excel Only Created Excel Subtotals with Filters On and Set to 'Steve Smith' using Only Excel

Use the Right-Click Menu "Filter with Double Click" Option
to Create & Remove Data Filters in the List Beginning in Cell A1


EZ-Subtotal Right-Click Menu for Creating Filters using 'Filter with Double Click' option
Use "Export Visible Data" to Copy Only Visible Cells - See #6 Below



2.  On-the-Fly Changing of Subtotal Types in Excel Created Subtotals

Right-Click a Subtotal Amount to Choose a New Subtotal Type for the Selected Outline Level

Outline Level 3 has been changed from "Total" to "Min" in Two Clicks.

Excel Only Created Excel Subtotals after changing Outline Level 3's Subtotal Type from Sum (Total) to Min On-the-Fly


3.  Add, Modify and Delete Column Totals On-the-Fly in Two-Clicks

Right-Click any Cell in a Column and Select from 12 Column Total Types

EZ-Subtotal created Column Totals automatically adjust when used with Excel Data Filters.

EZ-Subtotal Right-Click Submenu used for Maintaining Column and Subtotal Types Assigned to Fields


4.  Reorder Multiple Columns in a Single Step.

Use with both Subtotaled and Non-Subtotaled Data beginning in Cell A1.

EZ-Subtotal 'Field Re-order Dialog' for changing the order of multiple columns in a single step


5.  Hide / Unhide Multiple Fields in a Single Step.

Use with both Subtotaled and Non-Subtotaled Data beginning in Cell A1.

EZ-Subtotal 'Hide / Unhide Dialog' for hiding / unhiding multiple columns in a single step


6.  Export only Visible Data (Rows & Columns) to New Worksheet.

Use with both Subtotaled and Non-Subtotaled Data beginning in Cell A1.

EZ-Subtotal Export Visible Data option on the Sigma icon's Menu on the EZ-Subtotal Toolbar

Filtered Worksheet Data from #1 Above after Being Exported - it is identically formatted.

EZ-Subtotal Exported Worksheet from #1 above with all hidden Rows and Columns deleted





Try EZ-Subtotal

New Version 02/24/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