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.
|
|
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.
Use the Right-Click Menu "Filter with Double Click" Option to Create & Remove Data Filters in the List Beginning in Cell A1
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.
|
|
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.
|
|
4. Reorder Multiple Columns in a Single Step.
Use with both Subtotaled and Non-Subtotaled Data beginning in Cell A1.
|
|
5. Hide / Unhide Multiple Fields in a Single Step.
Use with both Subtotaled and Non-Subtotaled Data beginning in Cell A1.
|
|
6. Export only Visible Data (Rows & Columns) to New Worksheet.
Use with both Subtotaled and Non-Subtotaled Data beginning in Cell A1.
Filtered Worksheet Data from #1 Above after Being Exported - it is identically formatted.
|