EZ-Subtotal™ Features
In Minutes Learn to Create Better Excel Subtotals
Utilizing these EZ-Subtotal Excel Subtotaling Enhancements
Sample subtotaled worksheet
created from non-totaled data in 13 clicks and 10 seconds.
Using only Excel you can not create "Subtotals" like these!
EZ-Subtotal Created Excel Subtotals with
Automatic Sorting, Mixed Subtotal Types,
Optional Bolding, Shading and Column Borders
Subtotals created using only Excel with
Three Erroneous Grand Total Rows
and Requiring Seven Outline Levels
EZ-Subtotal State & City Subtotals
at Excel Subtotal Outline Level 3
Exported EZ-Subtotal State & City Subtotals
with Hidden Rows & Columns Deleted
EZ-Subtotal Subtotals with Data Filters Set
and Correctly Exposing the Subtotal Rows
|
|
Automatic Sorting of all Break Fields
Completely Eliminates Pre-Sorting of Data
Add Sort Fields Beyond the Break Fields
Add / Change Sorts with Subtotals Turned On
Up to Six Sort Fields including Break Fields
Reorder Multiple Columns in One Step
Performs the "Cut" & "Insert Cut Cells" for you
Hide and Unhide Columns in One Step
View Descriptions of all hidden columns
Add, Change & Remove Column Totals
Choose from 12 Different Column Total Types
Column Totals adjust to Data Filters
Create from anywhere within the Column
Created for Row 2 through last row of Data
Subtotaling removes the Column Total Row
Mix Subtotal Types on All Subtotal Rows
Mix Count, Sum, Avg ... All 11 Subtotal Types
Mixing creates fewer Excel Subtotal Outlines
Subtotal Percent and Average Fields
Not possible using standard Excel Subtotals
Automatically Uses the Identical Excel Formula
Prevents Display of Excel Divide by Zero Errors
Correctly Subtotal Blanks in Break Fields
Unlike Excel, EZ-Subtotal Groups All Blanks
Change Subtotal Types On-the-Fly
Make changes without removing Subtotals
Dynamically Add & Remove Subtotal Fields
Change Subtotaled Fields with Subtotals On
Double-click to Set / Unset Data Filters
Unlike Excel, correctly exposes Subtotal Rows
Unlike Excel, the selected cell remains visible
Export Visible Data to New Worksheet
Retains all formatting & removes hidden data
Retains Subtotals, Grand Totals and Outlines
Remembers Sorts, Breaks, Fields & Types
Turn Subtotals Off and On in 2 Clicks
Temporarily Turn Subtotals Off
Turn Subtotals Back On in 2 Clicks
Permanently Delete Subtotals
Creates Column Totals for Subtotaled Columns
Completely Bold and Shade Subtotal Rows
Bolding & Shading are separate and optional
Add Borders around the List and Columns
Borders are Optional
Easily Turn View & Print Gridlines On & Off
Stops Excel's Erroneous Grand Total Rows
This bug occurs in all Versions of Excel
Eliminates ####s Due to Narrow Columns
Auto-sizes Break & Subtotaled Fields
Creates a "Freeze Pane" for Descriptions
Row 1 Field Descriptions are Always Visible
Set Row 1's Default Background Color
Set Total Row's Default Background Color
View only Subtotal Fields at Outline Levels
Automatically Hides All Non-Subtotal Columns
Rank or Resort by Subtotal Amounts
Resort by the Subtotals of any Subtotaled Field
Instantly Calculates All 11 Subtotal Types
Plus Calculates Median & Mode Formulas
Calculations are made at every subtotal break
Easily analyze by any calculation
Calculates for only the visible data
Produces 100% Pure Excel
Use Worksheets without EZ-Subtotal Installed
Convenient Access to EZ-Subtotal Features
Installs and Uninstalls in Seconds
Intuitive - Learn in Minutes by Using
Watch 0:33 Video & be Ready-To-Use! 
Life Time Free Updates and Upgrades
Simply Download & Install the Latest Version
Purchase within Excel to Self-Register
|
Sample List with Column Totals
Used to Create these Subtotaled Worksheets
|
|
EZ-Subtotal Requirements
Non-Subtotaled Data Beginning in Cell A1
One row of unique Field Descriptions
Optional blank row and Column Total row
Virtually the same requirements as Excel
Microsoft® Excel® 2000, XP, 2003, 2007
Windows® 2000, XP, 2003, Vista
|
|
|
PRODUCTS