Data Presentation Products   Microsoft Excel Tools     Microsoft Excel Add-ins

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

HOME > PRODUCTS > EZ-Format

EZ-Format™ for Microsoft® Excel® The Only Add-in to Completely Automate Creation of Identically Formatted Worksheets. Quickly create Re-Usable Worksheet Formats for identically formatting data in seconds. EZ-Format now includes 'Aged Date', 'Running Total', 'Percent of Total', 'Reformatted Date' and 'Conditional Negative' Custom Excel Formula Fields in addition to standard Excel Formula fields! Each Custom Excel Formula Field was Created in Several Clicks! Reproduce Formulas with Re-usable Worksheet Formats! Learn EZ-Format in Minutes! Save Hours Creating More Useful Worksheets! EZ-Format includes free use of EZ-Split & EZ-Subtotal & all EZ-Stat features are built-in for use with EZ-Format worksheets. Purchase EZ-Format for $39.95 and use EZ-Subtotal ($29.95) and EZ-Split ($29.95) free.

This Better Formatted and Better Subtotaled Worksheet was Created for the First Time in Less than Five Minutes! Using a Re-usable Format it can be Re-Created in Ten Seconds! This Ranked or Re-Sorted Subtotaled Worksheet By Adjusted Sales Amt was Created in 2 Clicks! 'Pct of Sales' Subtotals use same Division Formula used for data wrapped in another formula to prevent display of #DIV/0! errors. New!  EZ-Format Excel 2007 / Excel 2010 Ribbon Every add-in's single install works with Excel 2000, XP, 2003, 2007 and Excel 2010 Here Now!  The New EZ-Format Toolbar for Excel 2000, XP and 2003 Easily access every major EZ-Format formatting and analysis feature! EZ-Format Free for 15-Days! Download EZ-Split Free 15-Day Trial. Download EZ-Subtotal Free 15-Day Trial. Better, Faster, Easier Formatting, Subtotaling and Analysis! Create Re-usable Worksheet Formats to Automatically and Identically Format Excel Data in Seconds. Utilize Excel's Most Popular Formatting Features. Styles, Subtotals, Formula Fields, Filters, Conditional Formatting, Column Totals, Re-ordering, Hiding, Bolding, Shading, Displaying Subtotal Outline Levels, Viewing & Exporting Filtered Data, ... Create Excel Formula Fields and Re-create using Formats. Unlike when using only Excel, create formula fields directly in subtotaled data. Instantly Modifiable Subtotals work with Excel Data Filters. Change Sort Fields, Subtotal Break Fields, Subtotaled Fields and Subtotal Types. Make all changes without removing and re-creating the subtotals. Better Data Analysis, and many additional Excel Enhancements. Automatically re-create formula fields, subtotals and worksheet formatting! Simply Choose from the List of Re-usable Worksheet Formats for only the Fields in the Original Data. Use EZ-Subtotal and EZ-Split FREE with EZ-Format! EZ-Subtotal Subtotals without EZ-Format's additional formatting features! EZ-Format and EZ-Subtotal have identical subtotaling capabilities. EZ-Split splits worksheets in seconds retaining the formatting & subtotals! Fast and Flexible Splitting of Worksheets, Workbooks & Name Fields. EZ-Stat's Quick, Range and Full Stats are Built-in! Instantly Calculate 29 Standard Excel Formulas without any format changes! Count, Sum, Min, Max, Avg, Median, StdDev ... pick from all 29 Excel Math and Stat Formulas EZ-Format's Exclusive Time-Saving Features for: Quickly Formatting Excel Data for the first time, Optionally Saving and Re-using Worksheet Formats, and Better Analysis and Manipulation of Excel Data. Manually implementing these features is time-consuming and virtually impossible! EZ-Format always Formats an Automatic Copy of the Original Data EZ-Format only copies and formats the visible rows of Original Data Use EZ-Subtotal to Create Column Totals and Filters in the Original Data EZ-Format and EZ-Subtotal Column Totals and Subtotals Auto Adjust to Data Filters EZ-Format and EZ-Subtotal Work Best with Excel Data Beginning in Cell A1 EZ-Format's Re-usable Formats Minimizes Changes to Unformatted Data Excel Styles are Auto Created, Applied & Saved in Re-usable Formats Setting Excel Filters in any column always exposes Subtotal Rows Automatic Sorting always occurs at the beginning of Subtotaling All 11 Column Total Types Auto Adjust to Data Filters Temporarily View Hidden Fields Reorder Multiple Fields in a single step Mixing Subtotal Types at all Subtotal Breaks creates fewer Outline Levels Temporarily turn Subtotals Off and On in a Single Click Change Break Fields, Subtotaled Fields and Sorts without removing Subtotals Subtotal Rows are optionally Bolded and Gradient Shaded Drag Constant Data, like a Name, to Subtotal Rows Dragged Reference Data is automatically displayed with the subtotal outline levels Double-clicking a Value optionally Sets & Unsets the Excel Data Filter Easily View (Walk) the Data and the Subtotal Rows for individual Values in any Field Automatically hide empty columns when viewing Subtotals at Outline Levels Subtotal Break Field Values are Dragged to Lower Level Breaks for Better Viewing Rank or re-sort subtotaled data by the subtotal amounts of any subtotaled field Conditional Formats are only applied to cells at the same Subtotal Outline Level Worksheets are created Printer-Ready Individually Set Fields to be a Fixed Column Width Set Fixed Width Fields to Wrap the Data Columns are Optimized to their Narrowest Width if not defined as Fixed Width Descriptions will be auto wrapped to two lines to narrow a columns width Automatically Replace Field Descriptions when Re-using Worksheet Formats Quickly Create and Automatically Re-create Excel Formula Fields NEW! Turn numbers negative based on values in 2nd field NEW! Create 12 different Re-formatted Date Fields Add additional spacing between major subtotal groups for easier viewing Define Custom Page Headers and Page Footers Set & Save Margins and Print Orientation Export only Visible Data to a New Worksheet Retaining all Formatting Quickly & Easily Create Reusable Worksheet Formats Re-use Formats to Automatically and Identically format new data Create Multiple Re-Usable Worksheet Formats for each Set of Field Descriptions EZ-Format Always Copies the Original Data Before Formatting Use EZ-Split to Split EZ-Format Worksheets and to Retain the Subtotals EZ-Stat's Analysis Features are built-in to EZ-Format Calculate all 29 Excel Math and Stat formulas with no formatting changes EZ-Stat's "Full Stats" calculates formulas at changes in up to four fields NEW! Aged Date Custom Formula Field NEW! Percent of Total Custom Formula Field NEW! Running Total Custom Formula Field EZ-Format's re-usable Worksheet Formats are automatically matched to the Source Data Split Worksheets in Seconds! EZ-Split's Exclusive Features Split Worksheets for Values in any field retaining all Formatting Split worksheets into one new workbook or multiple new workbooks Split selected worksheets in one workbook to new individual workbooks Split one Worksheet to multiple worksheets by selected columns Split text fields to extract the left, center or right data. Splits "Names" in seconds Spread a numeric field to new columns for unique values in 2nd column Split thousands of records for hundreds of values in seconds Retains EZ-Format's Subtotals and all Worksheet Formatting Merges worksheets with the identical fields from one or more workbooks Complete use of EZ-Split is included FREE with EZ-Format

New! Automatically Format Any PivotTable Drill Worksheet. Create Permanent Re-Usable Drill Worksheet Formats that are independent of PivotTables. Great for use with PivotTables periodically built from new data for the same source fields. EZ-Format's Completely Automatic Worksheet Formatting EZ-Format's Export / Copy Only Visible Worksheet Data Creating and Changing Excel Subtotals On-the-Fly Creating and Reusing Excel Worksheet Formats   EZ-Split's Splitting Worksheet Data for Selected Values   Making Bolded Shaded Subtotals Mixing Counts Sums and Formulas   Dragging Data Like a Phone Number to Subtotal Rows   Sorting / Ranking Subtotaled Data by the Subtotal Amounts Download EZ-Format 15-Day Trial for automatic re-creation of EZ-Format Excel subtotals, better Excel Subtotaling, Exporting / Copying Only Visible Excel Data, ... All Add-ins Install and Completely Uninstall in Seconds All Add-ins include Free Lifetime Updates and Enhancements Use with Excel 2000, XP, 2003, 2007 & 2010 on Windows 2000, XP, Vista & Windows 7 Information on the Six Automatic Demos included with EZ-Format Screen Shots and Descriptions of the EZ-Format Excel Add-in Tool Features for Formatting Excel Data and Worksheets and Creating Excel Subtotals and Data Filters! Includes every enhancement for Formatting Excel Data and Creating Excel Subtotals. EZ-Format separates Excel data maintenance tasks from Excel data formatting and Excel data analysis tasks to make working with Excel data faster, easier and better. This could be an Excel List used for manually maintaining data and calculated fields. It could also be data imported into Excel from an application or from a data base extract. It is easier to manually maintain data when it is not subtotaled and when it is minimally formatted. EZ-Format is the fastest and easiest way to format most Excel data for viewing, printing and data analysis! The same Excel List Data after 8 Clicks and 15 Seconds of EZ-Format Formatting. This formatted worksheet was created from an automatic copy of the original worksheet's data. These are the EZ-Format features applied to the automatic copy of the original worksheet. Both data and formatting of the original worksheet are un-modified by EZ-Format's automatic copying Descriptions and Data are Auto-Sized without Soft Returns • Data Filters are automatically created Description and Total Rows have a Background Color • A Freeze Pane is created between row 1 and 2 State & City fields are automatically moved to the left • Data is automatically sorted by State & City Subtotals for State & City were created • State values are automatically dragged to City Subtotal Rows Every Subtotal Row mixes a Count and two Sums • Excel Styles were created and applied to the data Subtotal Rows are completely Bolded and Gradient Shaded • The Worksheet is Formatted for Printing The same Excel List Data with Equivalent Subtotals Created Using Only Excel These are some of Excel's data formatting deficiencies. Excel formatting is performed on the original data unless a manual copy of the data is first made. You must remember to first sort the data in the order of the subtotal break fields (State and then City). You must remember to create the subtotals in the proper order (State first for Sales Amt and Owed Amt and again for a Count of Names), then repeat the process for City subtotals for the same three fields. Excel always creates extra subtotal rows when mixing counts and sums or any of Excel's subtotal types. Columns are wider than they need to be because descriptions and data are not optimally auto-sized. Break fields are not dragged for easier viewing; i.e., State values are not dragged to City Subtotal rows. Excel never mixes different subtotal types, like Count and Sums, together on the same subtotal row. There are three additional subtotal outline levels because Excel subtotaling does not mix subtotal types. The subtotal rows are not completely bolded and gradient shaded for easier viewing. The Grand Totals are confusing and contain Excel subtotaling errors - 3 extra Grand rows. The worksheet is not automatically formatted for printing. Not easy, not fast, not nicely formatted, buggy, and don't make a mistake! Could you manually duplicate EZ-Format's formatting? Certainly, but not in 8 clicks and 15 seconds! EZ-Format adds, modifies and removes Excel Subtotals on-the-fly. Unlike Excel, you never have to remove and re-add subtotals when changing subtotal break fields, sort fields, subtotaled fields, or subtotal types. Unlike Excel, use formulas for Subtotals for Percent and Average fields. One click specifies the use of an Excel formula for Percent and Average fields, and EZ-Format wraps the formulas in code to prevent the display of Excel # Errors. Excel State and City Subtotals - 1 Click. Excel does not automatically hide empty columns when displaying only subtotals with no detail. EZ-Format State and City Subtotals - 2 Clicks. EZ-Format automatically hides empty columns and changes the gradient shading. Two clicks exports the visible rows and columns of the above EZ-Format worksheet. Subtotal outlines are automatically removed when only subtotals are exported. Excel State Only Subtotals - 1 Click. Once again, Excel does not automatically hide empty columns. EZ-Format State Only Subtotals - 2 Clicks. Once again, EZ-Format automatically hides empty columns and changes the gradient shading. EZ-Format City Only Subtotals - 2 Clicks - there is No Equivalent Excel Capability. Unlike Excel, EZ-Format can display only the subtotal records at any single subtotal outline level. Excel almost never displays Subtotal Rows when using Data Filters with Subtotaled Data. This is what Excel displays after setting the 'Name' filter to 'Steve Smith'. EZ-Format always displays Subtotal Rows when using Data Filters with Subtotaled Data. EZ-Format always displays subtotal rows and the grand total row when Excel data filters are set. Example of City and State Subtotals re-sorted / ranked in descending order by Sales Amt. In several clicks all State, City and Detail rows are sorted in descending order by Sales Amt. There is no Excel equivalent for this useful feature of ranking data after it has been subtotaled. Example of EZ-Format Conditional Formatting of data cells in a Subtotaled Worksheet. In subtotaled data EZ-Format applies conditional formats to only the cells at the selected level. Example of EZ-Format subtotals by Name created from a second automatic copy of the original, separate and manually maintained or imported Excel worksheet data. Notice EZ-Formats ability to automatically drag reference data (the Phone No) to subtotal rows. Example of the 'Name' only subtotals with the automatically Dragged 'Phone No' Field. Data dragged to a subtotal level is always included in the display of the subtotals at that level. In EZ-Format worksheets Excel data filters are set and un-set by double left-clicking. In this example a cell containing 'CA' was double left-clicked to set the Excel filter for State to 'CA'. Also easily set subtotal row height to 1.0, 1.25, 1.5, 1.75 or 2.0 times the standard row height. Remember to manually maintain the data only in the original non-EZ-Format worksheet. Never manually maintain data in an EZ-Format formatted worksheet that is being used for viewing, printing and data analysis of an automatic copy of the original data. Easily split the visible data in one worksheet into multiple worksheets and output the worksheets to either one new workbook or to multiple new workbooks. Quickly Split the data in one Worksheet into Multiple Worksheets or Workbooks EZ-Format created subtotals are automatically recreated in Split Worksheets. EZ-Format created Split Worksheets in a single Workbook with one Tab per Value In two clicks calculate 8 to 29 commonly used Excel formulas and Excel functions. Quick Stats calculates 8 Excel Formulas for All Data or the Data for a Single Value Range Stats calculates either 25 or 29 Excel Formulas for the selected numeric field for (1) all data in the column, (2) the selected range of data in the column, or (3) for the range of data included in any subtotal in the column. In addition, limit Range Stats to only the data for one selected non-numeric value. Download Free 15-Day Trial of EZ-Format Add-in Installs and Completely Uninstalls in Seconds. Securely purchase from inside Excel to automatically self-register. Liftime free updates - simply download and install the latest version. EZ-Format Version 9.1 for Microsoft Excel          SLP-US $39.95 Better subtotaling is only one of over three dozen exclusive features not in Excel.           Features like automatically viewing subtotal rows when data filters are set. Viewing only the data for one value in any field, and walking through the values. Manipulating formatted printer-ready data in ways impossible if using only Excel! Take the Getting Started Tour to quickly learn how to use EZ-Format! Latest CNET version is 9.1 on July 2, 2010. New Version 07/03/10

DPPI Add-ins for Excel are Windows Vista®, Windows 7® and Microsoft® Office 2007/2010 Compatible HOME PRODUCTS DOWNLOADS PURCHASE MOVIES FAQ SUPPORT CONTACT US ABOUT SITEMAP COPYRIGHT © 2002-2010, 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.