EZ-Format for Excel 5.1
Automates dozens of Excel features too time consuming and difficult to manually implement.
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 2 / XP / 2003 on Microsoft® Windows® 2 / 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
tags
microsoft excel subtotal rows any field the data subtotal break and export subtotaled data break field the subtotal bolded and empty columns data filters reference data
Download EZ-Format for Excel 5.1
Download EZ-Format for Excel 5.1
Purchase: 
Buy EZ-Format for Excel 5.1
Similar software
EZ-Format for Excel 5.1
Data Presentation Products
Automates dozens of Excel features too time consuming and difficult to manually implement.
Cabri 3D 2.0.0.279
CABRILOG SAS
Until now three-dimensional geometry was difficult to teach – the complexity of designs in perspective, models that are difficult and time-consuming to construct.
StockProfits 2.5
Modern Co
StockProfits is a time-saving utility which will help those of us who make lots of trades with a stock broker every year.
Text2GED 1.1
RKS Consulting, Inc
Text2GED will quickly and accurately convert genealogy data displayed in a web browser into standard GEDCOM 5.
DigDB for Excel 7.1.3
Excel Add-ins
Empower Excel for difficult query and data manipulation, delete duplicates and fix links.
FileMonkey 10.88
MonkeyJob Systems Inc
The FileMonkey file operations package automates common time consuming file management tasks.
Web Finalist 0.9
FirstStop WebSearch LLC
Web Finalist is a real-time web search utility that helps online researchers scan collections of web pages for specific information.
UB-92 Fill & Print 1.0
UB-92 Software
Filling out UB-92 forms is a difficult and time consuming process, even when done on a computer with one of the generic form filling programs.
Theme Installer 1.0
Left Side Software Pty Ltd
Theme Installer is an application that automates the process of installing Plus! Themes.
ISSI 5.1.9.0
LOGAN
In the past adding some customization to Jordan Russell's Inno Setup one had to look for pieces of code and implement them into their own script.
39.00 
Trial
0K
Windows Vista 
RSS