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 Fastest First-Time Formatting of Data and the Fastest Automatic Formatting of Data for Fields Previously Formatted. Quickly create Re-Usable Worksheet Formats for identically formatting new data in several clicks. New! EZ-Format now includes 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. Download EZ-Format to try all three add-ins at the same time.           Faster, Better Formatted, Bug Free Excel Subtotals and Dozens of Enhanced Data Analysis and Maniplulation Features. New!  EZ-Format, EZ-Subtotal, EZ-Split & EZ-Stat Excel 2007 Ribbons Every add-in's single install works with Excel 2000, XP, 2003 and Excel 2007 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. 10-20-2008 EZ-Format's Completely Automatic Worksheet Formatting 10-27-2008 EZ-Format's Export / Copy Only Visible Worksheet Data 11-06-2008 Creating and Changing Excel Subtotals On-the-Fly 11-07-2008 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 in Split Worksheets, 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 and 2007 on Windows 2000, XP and Vista Information on Six Automatic Demos included with EZ-Format   Save Worksheet Formats for Re-use with New Data. Automatically Format New Data Using Saved Formats. Make Excel Subtotals Mixing Excel Subtotal Types. Split Worksheets into Multiple Worksheets, into One or Multiple New Workbooks for Values in any Field. Over three dozen Excel Formatting and Excel Data Analysis enhancements too time consuming to perform manually! Highly rated Microsoft Office Marketplace Excel Add-in for formatting and subtotaling data! As seen on Microsoft Office Marketplace and CNET download.com New! Use EZ-Split to split data in one worksheet to identically formatted worksheets in new workbooks, save selected sheets to individual workbooks, save data for selected values to one new worksheet, spread a numeric field to multiple new columns, split name and text fields, and fill blank cells. EZ-Split Product Page includes short videos on each of these six features. Try EZ-Format Free for 15-days! Securely Purchase for $39.95 New Version 11/15/2009 Download and run the automated demos to quickly see all EZ-Format Features. If you have questions after the demos call our toll free number. Installs and uninstalls in seconds. Free updates for Life. "Best Excel Tool for formatting, subtotaling and analysis!" Over three dozen Excel formatting and Excel data analysis enhancements with better subtotaling. EZ-Format makes Excel Formatting faster and easier! Perform time consuming Excel formatting features in seconds! Save and re-use worksheet formats to create identical worksheets in seconds! 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. Question!  What is the fastest and easiest way to format most Excel data for viewing, printing and data analysis? The answer after these screen shots! 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. EZ-Format Conditional Row Formatting using both the Background Color and the Font Style of all qualifying Excel Conditional Formats for the 'Sales Amt' data. Using only Excel, conditional row formatting can only be done by writing complex VBA macros. EZ-Format created Data Filter using only the qualifying 'Sales Amt' Conditional Formats. Filtering only the rows satisfying an Excel Conditional Format is an exclusive EZ-Format feature. 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. EZ-Format!  The fastest and easiest way to format Excel data for viewing, printing and data analysis? Maintain Excel Data in unformatted 'original' worksheets! Separating the worksheet used for data maintenance from the worksheets used for data formatting and data analysis makes is easy to create multiple differently formatted worksheets from the same set of original data. In two clicks export only the visible rows and the visible columns in any EZ-Format formatted worksheet. All EZ-Format 'Export' worksheets are actually new original data worksheets even though they look exactly like an EZ-Format formatted worksheet. 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. The EZ-Format Paradigm is Simple.    •    Use Excel to maintain data in separate worksheets hereafter referred to as 'original' data worksheets.    •    'Original' data also refers to data imported into Excel from applications and from database extracts.    •    Do not maintain data directly in EZ-Format created worksheets.    •    Only create new fields in 'original' data worksheets.    •    Never create new fields directly in EZ-Format created worksheets.    •    Use Excel or EZ-Calc for creating Excel function fields in 'original' data worksheets.    •    EZ-Format creates formatted worksheets from a automatic copy of an 'original' data worksheet.    •    Easily create multiple different EZ-Format worksheets from the same 'original' data worksheet.    •    Use EZ-Format created worksheets for viewing, printing and analyzing the 'original' data.    •    Use EZ-Format for formatting Excel data.    •    Use EZ-Format for formatting Excel worksheets.    •    Use EZ-Format for creating Excel subtotals and for subtotaling Excel data.    •    Use EZ-Format for reordering Excel data.    •    Use EZ-Format for sorting Excel data.    •    Use EZ-Format for hiding Excel data rows and for hiding Excel columns.    •    Use EZ-Format for analyzing Excel data.    •    Use EZ-Format for creating Excel data filters and for setting and un-setting Excel data filters.    •    Use EZ-Format for automatically creating Excel Styles and for automatically applying Excel Styles.    •    Use EZ-Format to split Excel data in worksheets.    •    Splitting Excel worksheets can be done for both 'original' worksheets and EZ-Format worksheets.    •    Use EZ-Calc to split the data inside the cells of one worksheet column into one or more new columns.    •    Use EZ-Format for exporting Excel data to new worksheets.    •    Only visible data (rows and columns) is exported by EZ-Format.    •    EZ-Format exports from 'original' data worksheets are new 'original' data worksheets.    •    EZ-Format exports from EZ-Format formatted worksheets continue to be EZ-Format worksheets. Features of EZ-Format for Microsoft Excel Add-in Tools for Formatting Excel Worksheets and Excel Add-ins for Making Excel Subtotals. Quickly format the Excel List data in one worksheet into a completely new and separate formatted worksheet.    •    EZ-Format always automatically copies the user's original data to a completely new worksheet prior to formatting the data.    •    The original data is typically an Excel List beginning in cell A1, and the original data can include column totals, no totals or Excel subtotals.    •    The original data worksheet should include the same fields it would contain if the user were going to manually format and subtotal the data within the same worksheet, including any Excel formula fields.    •    EZ-Format users can quickly format the original data in one Excel worksheet into multiple differently formatted worksheets.    •    Users maintain their original data in separate worksheets and periodically use EZ-Format to quickly create completely new formatted and subtotaled worksheets for use in viewing, printing and analyzing their data.    •    Maintaining original Excel data is quicker and easier when the separate original data worksheets are only minimally formatted.    •    EZ-Format makes it possible to easily separate Data Maintenance tasks from Data Formatting and Data Analysis tasks.    •    Separating data maintenance tasks from data formatting and data analysis tasks makes each of these Excel tasks faster and easier. Split the Data in One Excel Worksheet into Multiple Excel Worksheets or Multiple Excel Workbooks for only the designated values in any worksheet column.    •    The "Split" Excel worksheet data feature included with EZ-Format works with both original data worksheets and EZ-Format formatted worksheets.    •    The Excel worksheet data to be split can be non-totaled, totaled or subtotaled.    •    The 'split' data output in the new worksheets and workbooks is never subtotaled.    •    The 'split' data is not removed from the original worksheet.    •    If the source worksheet for the splitting of Excel worksheet data is subtotaled, then the fields that were subtotaled in the original worksheet will be column totaled in the output worksheets and workbooks.    •    To split a worksheet into multiple worksheets and workbooks you first designate the field to be used for splitting and then you designate the indiviual field values to be split from the original worksheet.    •    Only the designated values in the designated field will be split into new worksheets and workbooks.    •    When splitting one worksheet apart, the worksheet outputs can be either (1) multiple individual worksheets in one workbook or (2) multiple new workbooks each with one worksheet for one of the selected values from the designated splitting field.    •    The split data output workbooks are automatically named by the splitter program, and the name can optionally include the current date in yyyy-mm-dd order with zero filled months and days.    •    By default the file name of the new split data workbooks consists of the name of the field being used for splitting the data, an underscore character, optionally the date in yyyy-mm-dd order with a trailing underscore, and the value of the designated field contained in the workbook.    •    The Tab name of all split data worksheets is automatically set to the value of the designated split field contained in the worksheet.    •    Hidden columns can be optionally deleted from the output worksheets and workbooks when splitting the data in an Excel worksheet.    •    Hidden rows containing the currently selected value for the selected field can be optionally deleted from the output worksheet and workbook when splitting the data in an Excel worksheet.    •    The location of the output folder used for creating the new split data workbooks can be user specified. The Default Formatting of EZ-Format formatted Worksheets.    •    The formatted data is in the same order as the original data.    •    Excel Styles are automatically created for and automatically applied to each field.    •    Each column is automatically auto-sized to the wider of either (1) the minimum width required for the data and totals or (2) the minimum width required for up to two lines of field description.    •    In EZ-Format formatted worksheets the column width of each text field that is 'wrapped' in the original Excel worksheet is automatically set to be the fixed width of the original column.    •    Properly separated columns totals are created for the same fields totaled or subtotaled in the original data.    •    Fields using the Excel SUM Function in the original data are converted to use the Excel SUBTOTAL Function.    •    The SUBTOTAL function automatically adjusts for hidden rows, whereas the SUM function does not automatically adjust for hidden rows.    •    A row for properly separated column totals is always created even if no totals exist in the original data.    •    The field description row and the column total row are bolded and shaded for easier viewing.    •    The default 'Blue' background color of the field description row and column total rwo are user-modifiable by right-clicking in any field description cell or column total cell.    •    An Excel 'Freeze Pane' is automatically created between row 1 and row 2 to keep the field descriptions from scrolling off the screen.    •    By default, View Gridlines and Print Gridlines are automatically turned off.    •    The worksheet is formatted for printing and includes a user-modifiable and user-definable custom Page Header and Page Footer.    •    By default the Print Formatting includes (1) Date and Time, (2) Company Name (optional), (3) User Name (optional), (4) a user-specified Report Title and Report Subtitle, (5) the workbook file name and location and the worksheet tab name, and (6) a page number and count of the total number of pages.    •    The print-area is automatically set, and view page breaks is automatically turned off.    •    The print orientation is automatically set to either portrait or landscape using a user-definable minimum acceptable fit-to-page percentage for single wide portrait orientation.    •    If the actual fit-to-page percentage in Portrait orientation goes below the user-defined minimum acceptable fit-to-page percentage for single wide portrait, the orientation automatically switches to landscape.    •    The automatic print orientation can be over-ridden by explicitly setting the orientation to either landscape or portrait.    •    Excel Data Filters are automatically created for all fields in the worksheet.    •    Unless explicitly requested at the time of the initial formatting, Excel subtotals are not be initially created. Do not Add Columns or Delete Columns in EZ-Format formatted worksheets.    •    Do not directly add new columns to EZ-Format formatted worksheets.    •    If you need to add a column, add the column to the worksheet containing the original data.    •    Do not directly delete columns from EZ-Format formatted worksheets.    •    If you need to delete a column, delete the column from the worksheet containing the original data.    •    If you can not delete the data or do not want to delete the data from the original worksheet, hide the data in the EZ-Format formatted worksheet.    •    The EZ-Excel toolbar contains an icon for easily hiding and un-hiding columns in EZ-Format formatted worksheets.    •    The EZ-Excel toolbar also contains an icon for toggling all of the columns designated as hidden between being visible and being hidden.    •    By default, the background color of the field descriptions for visible 'Hidden' columns is 'Yellow', not 'Blue'.    •    The default background color of the field description for visible 'Hidden' columns can modified by right-clicking in the field description of a visible 'Hidden' column.    •    Hidden columns are not included in the automatic calculation of the print orientation.    •    The automatic print orientation can switch between Portrait and Landscape as columns are hidden and un-hidden.    •    Unless currently visible, columns designated as being hidden are automatically deleted from the new worksheet created by using the "Export Visible Data" option on the "U" icon's pop-click menu.    •    When using the "Split" worksheet feature included with EZ-Format, there are separate options for deleting hidden rows and deleting hidden columns from the new workbooks and new worksheets created from either an original data worksheet or from an EZ-Format formatted worksheet. Making Excel Subtotals with EZ-Format is fast and easy and produces report quality formatted subtotals.    •    EZ-Format cuts the number of subtotal rows in half when creating subtotals of both counts and sums.    •    When making Excel Subtotals EZ-Format users can mix any combination of Sum, Count, Min, Max, Average, Stdev ... all Excel subtotal types ... on the same subtotal row.    •    Standard Excel Subtotals do not allow mixing of Excel Subtotal Types on the same subtotal row.    •    When using only Excel to create subtotals, a Count of the number of Sales Transactions and a Sum of the Sales Amts requires two different subtotal rows for each Customer.    •    When using EZ-Format created subtotals, a Count of Sales Transactions and a Sum of Sales Amts appear on a single subtotal row for each Customer.    •    With EZ-Format quickly add, change and remove Excel subtotal types for any field without having to first completely remove and then later re-add the Excel subtotals.    •    By default EZ-Format created Excel subtotal rows are automatically completely bolded and lightly shaded for easier viewing.    •    In addition, EZ-Format users can easily change the height of subtotal rows to make subtotals standout even more from the data rows.    •    Bolding, Shading and changing the Row Height of subtotal rows are not standard Excel subtotaling features. By default EZ-Format created Excel Subtotals are completely bolded and lightly gradient shaded for easier viewing, printing and data analysis.    •    Standard Excel Subtotals only bold the value in the break field and never gradient shade the rows for easier viewing.    •    Easily remove and re-add EZ-Format's complete bolding and gradient shading of subtotal rows. Unlike with Excel, Excel formuals can be used to compute subtotals for percent and average fields.    •    Summing percents or averages in a column always produces an incorrect result.    •    To correcly calculate a subtotal for percents and averages requires using the same Excel formula with the Sum subtotals of the two columns for which the percents or averages are being calculated.    •    When using EZ-Format to subtotal a column of Excel formulas, optionally use the identical Excel Formula or Excel Function to calculate the subtotals.    •    There is no Excel subtotalling option for using an Excel formula to calculate subtotals; Excel only uses the Excel SUBTOTAL function. With EZ-Format easily drag data in any field to the subtotal rows below the data for better viewing, printing and exporting to new workbooks.    •    e.g. Two clicks will drag the Customer Phone Numbers to the Subtotal rows of Sales by Customer.    •    e.g. When viewing only Customer subtotals with no customer detail the Phone Numbers are now visible. Automatically drag all higher level subtotal break field values to all lower level break field rows.    •    i.e. Automatically drag the State value to City Subtotal rows for subtotals by States and Cities.    •    i.e. When viewing only City Subtotal rows the State values for the Cities are now visible.    •    Higher level subtotal break field values are never dragged to all lower level subtotal break field rows when using standard Excel subtotals. View only the Subtotals at any Subtotal Level.    •    When viewing the subtotals for either a specific subtotal break or a subtotal break and all higher breaks, empty data columns are automatically hidden.    •    When viewing the subtotals for a specific subtotal break the gradient shading of the subtotal rows is automatically removed.    •    When viewing the subtotals for a subtotal break and all higher breaks the gradient shading of the lowest subtotal break rows is automatically removed. Automatically Sort Excel Data before making Excel Subtotals.    •    Never again waste time by forgetting to first sort the data before adding Excel Subtotals to data.    •    Automatically move Subtotal Break Fields to the left for better viewing and analysis.    •    Excel Subtotals are easier to visualize when break fields are in order on the far left. Reorder Multiple Excel Columns in one step.    •    Use EZ-Format to perform multiple Excel 'Cut' and 'Insert Cut Cells' commands to re-order worksheet columns.    •    The Excel Formulas in all columns automatically adjust as the columns are being re-ordered. Automatically create Excel Data Filters for all columns in an Excel worksheet.    •    After making Excel Subtotals use Excel Data Filters with the Excel Subtotals.    •    Unlike in Excel only created worksheets, in EZ-Format created worksheets Excel Subtotals work correctly with Excel Data Filters.    •    Unlike in Excel, all appropriate subtotal rows are visible when Excel Data Filters are set even though the subtotal rows do not contain the filter value.    •    Unlike in Excel, a single click walks and displays only the data and the subtotals for single data values in any column.    •    Double left-clicking a cell in an EZ-Format created worksheet sets the Excel Data Filter to the selected value rather than entering Edit mode inside the cell.    •    In general EZ-Format formatted worksheets are not used for maintaining the data which is still in the original separate Excel worksheet within the same Excel workbook.    •    To directly edit data inside the cell in an EZ-Format created worksheet select the cell and press F2. Directly editing cell data using F2 also works in Excel only created worksheets. Export only visible row and visible column data to a new Excel workbook.    •    Click the 'U' icon on the EZ-Excel toolbar and select 'Export Visible Data' from the icon's pop-click menu.    •    Use Excel Data Filters to set the visible data for exporting to a new Excel worksheet.    •    Use EZ-Formats Excel data filter walking feature to quickly switch between filter values in any column. Automatically Create or Make Excel Styles for each field in an Excel worksheet.    •    The automatically created Excel Styles are automatically applied to all data values in each field or column in the EZ-Format created Excel worksheet.    •    EZ-Format creates the Field Styles for EZ-Format formatted worksheets using either the Excel Styles (if not Excel's 'Normal' Style) or the Cell Formats of the original data. Use Conditional Formats to change background color and font of entire rows.    •    Upon request EZ-Format will automatically apply the backgound color, the font or both properties of a conditional format to all detail rows for which the Excel Conditional Format test is 'True'. Re-Sort subtotaled worksheet data by the subtotals of any field.    •    i.e. Re-sort data already subtotaled by Salesman and Customer by the total Sales for each Salesman.    •    This additional sorting ranks the Salesmen and their Customers in order by the Salemens total sales from highest to lowest or lowest to highest.    •    Resorting already subtotaled data by the subtotal values of any field is not a standard Excel Subtotaling feature, and if done manually it is both time consuming and difficult to perform. Creating and Applying Excel Conditional Formats is fast and easy.    •    When you create, modify or delete an Excel Conditional Format in one cell, using the standard Excel Conditional Format dialog from the EZ-Format modified right-click menu, EZ-Format automatically applies the same Conditional Format action to all data cells in the column, automatically skipping the cells on all subtotal rows. Worksheets are Printer-Ready with a Custom Page Header and Page Footer.    •    By default the Custom Page header includes the current date and time, an optional Company Name, a user-specified Report Title and Report Subtitle, and optionally the user's Name.    •    By default the Custom Page Footer includes the Workbook File Location and Name, the Worksheet Tab Name, the current page number, and the total number of pages.    •    Company Name and User Name are optional and are easily removed from all page formatting.    •    The Excel Template containing the default Custom Page Header and Page Footer is user modifiable.    •    The default Page, Header and Footer Margins used for all EZ-Format formatted worksheets are user modifiable. Display only the Subtotal Rows and non-blank columns at any single Subtotal Break Level.    •    The ability to display only the subtotal rows at individual subtotal breaks is not a standard Excel feature.    •    Automatically hiding empty columns when displaying only subtotal rows is not a standard Excel feature.    •    Hiding all subtotal rows to display only the detail data rows is not a standard Excel feature.    •    In standard Excel worksheets displaying only detail data rows requires the removal of Excel subtotals. Quickly calculate 29 commonly used Excel Functions and Excel Formulas.    •    Calculate Sum, Count, Average, Mean, Min, Max, Stdev, Rank, Range ... up to 29 similar Excel Functions for one numeric field, multiple numeric fields or all numeric fields within the data.    •    Calculate Excel Functions using all data, the data for only one non-numeric value, or for a selected range of data.    •    Instantly calculate the 29 Excel Functions and Excel Formulas without modifying the format of the EZ-Formatted data.    •    Export the results of the Excel Formula and Excel Function calculations to a seperate Excel worksheet.    •    Calculations of Excel Functions use only the visible data rows.    •    To exclude data from the Excel Function calculations hide the data rows using Excel Data Filters.    •    Subtotal rows are automatically excluded from the Excel Function calculations. View the number of unique data values in a column on the column's right-click menu.    •    By default, the number of "Unique Values" in a column displays on the column's right-click menu.    •    Unchecking "Unique Values" turns off the calculation of the number of Unique Values in a column.    •    The number of Unique Values in a column is not calculated for columns containing Excel formulas. EZ-Format - the way Excel formatting should be! Create printer-ready worksheets with dozens of automatic formatting features in seconds! EZ-Format never modifies your original data! Better formatted subtotals is only one of many formatting and analysis features! Features like Styles, Conditional Formats, and viewing Subtotal row data at any Level! Subtotals are bolded, lightly shaded, allow mixed types and are visible with filtered data! EZ-Format installs and completely uninstalls in seconds! Take the "Getting Started Tour" and see just how quick and easy data formatting can be! Use with EZ-Calc to create Excel formulas and seven custom fields including "Aged" dates! Features of EZ-Format for Microsoft Excel Add-in Tools for Formatting Excel Worksheets and the Excel Add-ins for Making Excel Subtotals.    •    Subtotals and Totals Microsoft® Excel® Lists containing no totals, column totals or subtotals.    •    Never modifies the original Microsoft Excel List.    •    Formats manually created Microsoft Excel subtotals or replaces with EZ-Format created subtotals    •    Saves time.  Manually created Subtotals requiring 79 clicks require 7 clicks with EZ-Format.    •    Optionally ranks subtotaled data by re-sorting all break field groups by the subtotals of any field.    •    Subtotal rows are completely bolded and lightly shaded for easier viewing.    •    Subtotal shading uses six light gray scale colors.    •    Allows mixing of subtotal types such as sums, counts and percents at each subtotal break.    •    For percent and average subtotals uses the same formula used for calculating the percents and averages of the data rows.    •    Suppresses display of Microsoft Excel #Errors for data formula subtotals and two other subtotal types.    •    Higher level break field values are dragged to all lower level subtotal rows.    •    Microsoft Excel Styles are created for all fields and assigned to all data.    •    Create a Statistical snapshot that includes the sum, average, minimum, maximum, standard deviation and optionally the mean for each field being totaled or subtotaled for any selected data value in any field.    •    Worksheets are printer-ready.    •    Print orientation is automatically set.    •    Page format includes Company, User, Title, Subtitle, workbook, worksheet and page numbers.    •    Page formats can include a user specified graphic when using Microsoft Excel XP / 2003.    •    Set default margins for all EZ-Format created worksheets.    •    Field descriptions can be wrapped for best fit and smallest overall column width.    •    Subtotaled data is automatically sorted by the subtotal break fields.    •    Optionally and automatically move subtotal break fields to the left-most columns in break field order.    •    Add, modify and delete subtotal fields in 2 clicks when subtotals already exist.    •    Drag non-break field data to subtotal rows for display with the subtotal outline level.    •    Set columns to hidden in two clicks.    •    Set columns to un-hidden in two clicks.    •    Toggle viewing and hiding of all columns designated as hidden.    •    Toggle subtotal bolding on and off.    •    Toggle subtotal shading on and off.    •    Toggle hiding and viewing of empty columns at each subtotal outline level.    •    Change the order of multiple columns at one time.    •    Microsoft Excel data filters are always created and correctly expose subtotal rows when set.    •    Double clicking sets and unsets data filters and correctly exposes subtotal rows.    •    Select a starting data value and walk the data filter values in any field.    •    Set a data filter to select subtotal groups and then show all data within just those groups.    •    Set subtotal row height to 1, 1.25,1.5,1.75 or 2 times the data row height.    •    Set the default subtotal row height multiplier.    •    Turn view gridlines off and on.    •    Turn print gridlines off and on.    •    Set the initial on / off state of view and print gridlines.    •    Export only visible rows in 2 clicks to create workbooks for emailing and reporting.    •    Select one or more or all values in any field and create separate worksheets of only the data for each selected value.    •    Display and export only detail records without having to remove subtotals.    •    Display and export the subtotal records for any single subtotal break level; un-bolded and un-shaded with empty columns hidden and dragged reference data visible.    •    Display and export the subtotal row records at and above any subtotal level; with empty columns hidden, dragged reference data visible and the lowest subtotal level rows un-bolded and un-shaded so as to appear as though they are detail data.    •    Conditionally format entire rows based upon the conditional formatting in any one column.    •    Adds the EZ-Format menu to the Excel Menu bar.    •    Adds the EZ-Format tool bar for accessing frequently used features.    •    Right-click menus in EZ-Format worksheets re-configure to reflect available EZ-Format features.    •    Includes a Sample Workbook containing instructions for quickly learning EZ-Format features.    •    Works with Microsoft Excel 2000 / XP / 2003 on Microsoft® Windows® 2000 / XP / 2003 Server.    •    All EZ products install in seconds, and completely uninstall as separate products.    •    All products self-register upon purchase if software is currently installed or is subsequently installed.    •    All products include life-time free updates for product enhancements and bug fixes. Flash Videos on the EZ-Format and EZ-Split Add-ins for Microsoft Excel Videos on Features of DPPI's Add-ins for Microsoft Excel   Released Runtime Exporting / Copying Only the Visible Excel Worksheet Data   10/28/2008   06:33     See how to correctly copy only the visible Excel worksheet data     and retain all data and worksheet formatting properties.   Changing Height of all Subtotal Rows in an Excel Worksheet   10/23/2008   01:52     See how to quickly change the Height of all Subtotal Rows     using EZ-Format and Xcelerator.   EZ-Format's Ad Hoc and Automatic Excel Formatting Overview   10/20/2008   03:47     Quickly format Excel Data on both an Ad Hoc basis and     Automatically using re-usable worksheet formats.   Create new Worksheets / Workbooks for each selected Value   10/07/2008   03:15     Create new Worksheets and Workbooks for the Data     for each selected Value in one Field.   Create Separate Workbooks for Sheets in current Workbook   10/07/2008   02:19     Create new separate workbooks for all or selected     sheets or tabs in the currently active Excel workbook.   Extracting or Splitting Subsets of an Excel Worksheet   10/07/2008   01:52     Extract or Split a Subset of the Data in an Excel     Worksheet for only the Selected Values in one Field.   Spreading the Numeric Values in one Excel Data Field   10/07/2008   02:21     Spread the Numeric Values in one Column to multiple New     Columns created for the unique values in a second Column.   Extracting from or Splitting an Excel Name or Text Field   10/07/2008   03:29     Use EZ-Split to Extract or Split the Left, Center or Right     portion of an Excel Name or Text Field.   Filling Blank Excel Data Cells with Data from Above   10/07/2008   02:23     Use EZ-Split to Fill Blank Excel Data Cells in either one Column     or the entire Excel List in three clicks.   Using EZ-Stat's 'Full Stats' to Quickly Analyze Excel Data   08/12/2008   04:10     Analyze Excel Data using up to 24 Standard Excel Formulas     calculated at changes in up to four sort fields.   Sort and Rank Subtotaled Data by any Fields Subtotals   08/06/2008   03:30     For easier Data Analysis Sort and Rank Subtotaled Data by the     Subtotal Amounts of any field using EZ-Format and Xcelerator.   Dragging Reference / Constant Data to Excel Subtotal Rows   08/04/2008   02:50     See how to quickly drag Reference Data / Constant Data to     Excel Subtotal rows using EZ-Format and Xcelerator.   EZ-Splits's Quick and Easy Worksheet Splitting Features   07/23/2008   03:11     See how to quickly and easily split one worksheet into multiple     worksheets in either one workbook or into multiple workbooks.   EZ-Format's Better Excel Subtotals Video No. 1   07/22/2008   03:21     See EZ-Format quickly and easily create better formatted Excel     Subtotals plus seven of over three dozen Excel enhancements.   Watch How Quick and Easy it is to Download, Install, Run the     Automated Demos, Pause and Uninstall DPPI Excel Add-ins   12/23/2007   03:45     See how fast and easy it is to perform these actions.   EZ-Format for Excel Demo   02/06/2007   04:17     Quickly format and subtotal unformatted data for better analysis!   EZ-Format for Excel In-Depth  (29 movie segments) 11/19/2005   21:00     Multiple short in-depth movies covering virtually every feature   EZ-Format for Excel Overview 11/01/2005   01:24     Quickly and easily add professionally formatted subtotals   Download Free 15-Day Trial of EZ-Format Microsoft Excel Add-ins & Excel Tools for Formatting Excel Data, Making Excel Subtotals and Splitting Excel Worksheets 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 7.3 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 7.2 on August 25, 2008. New Version 11/15/09

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