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.
EZ-Pivot for Excel 5.1
Data Presentation Products
Create PivotTables and PivotCharts in seconds.
Pivot Table Helper 1.0
Afalina Co., Ltd.
Pivot Table Helper makes working with pivot tables comfortable and fast.
EZ-Stat for Excel 2.1
Data Presentation Products
EZ-Stat creates commonly used Excel Statistics for the requested numeric fields.
SQL Converter for Excel 2.0
Peachtree Communication Systems
SQL Converter 2 for Excel is an easy-to-use tool that quickly converts your worksheets to real SQL database tables.
DigDB for Excel 7.1.3
Excel Add-ins
Empower Excel for difficult query and data manipulation, delete duplicates and fix links.
Tools for Excel Tables 1.2
Jabsoft
Tools for Excel Tables is a useful and reliable addin which combines the functionalities of Microsoft Excel in order to create more robust functionalities which let you extracting multiple conditional data, splitting tables, smart consolidation, merging tables, categorizing databases, extracting unique records, stratifying data and much more.
AutoFormat XL for Pivot Tables 1.5
Afalina Co., Ltd.
Pivot Table AutoFormat XL allows you to save pivot table formatting and to use it as a format template for your future pivot tables.
Merge Tables Wizard for Microsoft Excel 3.1.4
Add-in Express Ltd.
You have two separate Microsoft Excel worksheets with common columns e.
Excel Merge (Combine) Cells, Columns, Rows & Data Software 1.1
Sobolsoft
Excel Merge (Combine) Cells, Columns, Rows & Data Software is an application that will help you combine cells in Excel.