Creates printer-ready worksheets with dozens of automatic formatting features in seconds

Automates dozens of Excel features too time consuming and difficult to manually implement.

Quickly turn unformatted data into feature-rich printer-ready formatted worksheets.

With better subtotaling and automatically created Excel Styles. With counts and sums mixed on bolded and shaded subtotal rows, Excel data filters that work with subtotaled data, reference data dragged to subtotal rows, re-sorting subtotaled data from highest to lowest by the subtotals of any field. Easily view and export subsets of data.

Select values from any field and split data into separate worksheets. Includes over two dozen exclusive time-saving formatting and analysis features.

The 'Features' video and Getting Started Tour show how to use each feature. Use with EZ-Chart, EZ-Pivot and EZ-Calc to create better charts, PivotTables and calculated fields.

Here are some key features of "EZ Format for Excel":

￭ 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 the 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
￭ Use EZ-Calc to create eight useful types of calculated fields including Accounting-Type "Date Aging" and "Re-formatted Date" fields
￭ All products install in seconds, and completely uninstall as separate products
￭ EZ-Format, EZ-Chart, EZ-Pivot and EZ-Calc are included in the EZ-Deluxe product
￭ EZ-Deluxe is the economical way to purchase all four EZ products
￭ Upgrade to EZ-Deluxe from any one EZ product without a price penalty
￭ 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


Limitations:

￭ 15-day trial


Requirements:

￭ Microsoft Excel