Data Presentation Products   Microsoft Excel Tools     Microsoft Excel Add-ins

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

HOME > PRODUCTS > EZ-Format

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! See How to Create Excel Charts in Three Clicks from Fixed Subtotaled Data!

EZ-Format ™ for Microsoft ® Excel ® 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. Download 15-Day Trial     Purchase for $49.95 Latest update 01/14/2012 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 HOME PRODUCTS DOWNLOADS PURCHASE MOVIES FAQ SUPPORT CONTACT US ABOUT SITEMAP COPYRIGHT © 2002-2011, 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.