EZ-Format for Excel

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.

Main 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 of EZ Format for Excel:

15-day trial


Requirements of EZ Format for Excel:

Microsoft Excel

Free Download ( Evaluation | 2.3 MB )