NEW! XL-Subtotal Fixes Excel's Subtotaling Bugs! The only solution to completely correct Excel Subtotal Bugs in one click! GET the FREE Forever Subtotaling Bug Fix Now!
Fixes Multilevel Subtotals, Nested Subtotals, Subtotals in wrong Position / Column / Order, Incorrect Subtotal Outlines, Missing / Erroneous Grand Totals in Subtotals Above and Below.
The Subtotal "FIX" Feature on the Excel Ribbon and Excel Toolbar is FREE forever. After the Trial, purchase for $19.95 to keep using dozens of Subtotaling enhancements.
The Free Excel Subtotal Fix in XL-Subtotal benefits everyone using Excel Subtotals!
Better Formatting, Analysis and Increased Productivity!
Format and Manipulate Data in Ways that are Manually Impossible! Quickly Format Data Using Excel's Most Popular Features! Create Reusable Formats for Completely Automatic Formatting!
Mouse-over Ribbon for Tooltips and Click to Watch "How-to" Video on Highlighted EZ-Format Feature. After watching Video on YouTube, click "Back" (or Alt+"Left-Arrow") to return to this page. Videos cover all versions of Excel. Descriptions and Times of all Videos are on the New EZ-Format Movie Page.
Ribbon and Toolbar Menus with 10 Videos for Major Features.
Quick Stats Video
Three 'Split Sheet' Videos
Six 'Formula Field' Videos
Access the Identical Features from the EZ-Format Toolbar in Excel 2000, XP and 2003.
Coming Soon! Automatically correct Excel bugs in Subtotals below. Delete Grand Total rows and Outline Levels created in error, and create Subtotal Outlines omitted in error.
New! Double-click cells to quickly set and unset the filter value in Lists, Tables and Subtotaled data. In filtered subtotaled data, related subtotals and grand totals are automatically unhidden when subtotals are below the data. Exposing related subtotals and grand totals is impossible to do manually.
New! Copy only the visible rows in filtered Lists, Tables and Subtotaled data to a new worksheet retaining all formatting. Copied subtotaled data retains the Excel subtotal outlines.
New! Analyze data using any or all of Excel's 25 mathematical formulas. Analyze Lists, Tables and Subtotaled data without modifying the data. Analyze data as a whole or broken down by up to four dynamically selected break fields. Selected formula calculations are presented in an easy to read Excel PivotTable.
New! Create Custom Excel Formula Fields: Aged Dates, Reformatted Dates, switch values in one column to negative based on values in another column, Running Total fields and Percent of Total fields.
Split Lists and Tables by the unique values in any field creating multiple new Workbooks in seconds! Selectively exclude List and Table columns when splitting Lists and Tables beginning in cell A1.
New! Retain associated PivotTables and PivotCharts when splitting data in Excel Lists and Excel Tables. PivotTables and PivotCharts are automatically updated for the new source data in all new split workbooks.
New! Use EZ-Email to automatically Email Excel Workbooks to 'Embedded' and 'Linked' Addresses.
New! Includes 32 bit and 64 bit versions for Excel 2010.
EZ-Format is the Only Add-in For Excel to Automatically Create Identically Formatted User-Defined Worksheets.
After quickly formatting data, create Re-Usable Worksheet Formats to identically format new data for the same set of fields.
Installs and Completely Uninstalls in Seconds. Securely Purchase from inside Excel.
Use with Excel 2000, XP, 2003, 2007 & 2010 on Windows® 2000, XP, Vista® & Windows 7®.
We recommend running Windows Update for Windows and Office® before installing EZ-Format.
Exclusive Time Saving, Productivity Enhancing Features:
Quick and Easy Formatting Using Excel's Most Popular Features.
User Designed Reusable Formats for 100% Automatic Formatting.
Create Five Custom Fields and User-Defined Excel Formula Fields.
Better Formatted Subtotals are Easy to Create, Modify and Manipulate.
Subtotal Rows are exposed when Excel Data Filters are set.
Resort or Rank Subtotaled Data by the Subtotal Amounts.
Split Column-Totaled and Subtotaled Data by Values in any Field.
New! Selectively exclude columns from split worksheets / workbooks.
Export Visible Worksheet Rows retaining All Formatting.
Export Subtotals for any Break Field to Create Excel Charts.
Instantly Analyze Data using Excel's 29 Standard Formulas.
Use EZ-Format with manually maintained data, database exports, Site Server exports, Dynamics GP SmartList exports ... all Excel data.
Licensed by User and by Enterprise Versions of Office.
DPPI Add-ins for Excel are Windows Vista®, Windows® 7, Windows® 8 and Microsoft® Office 2007/2010/2013 Compatible