Data Presentation Products
 
Microsoft Excel Tools  
 
Microsoft Excel Add-ins  

   

 
  HOME
 

Microsoft Excel Add-ins and Microsoft Excel Tools
for 32 bit and 64 bit versions of Excel


New!   EZ-Free Add-in for Microsoft ® Excel ®

The Completely Free Add-in for Microsoft Excel!



The EZ-Free Excel Ribbon
Access the Identical Features from the EZ-Free Toolbar in Excel XP, 2000 and 2003.


Double-click cells to quickly set and unset
filter values in Lists, Tables and Subtotaled data.  Free!  

In filtered subtotaled data, related subtotals and grand totals are
automatically unhidden.  "Expose related Subtotals" for manually set filters.
Use Delete Hidden Rows to create an identically formatted copy of the visible data.

Automatically fix Excel Subtotaling Errors.  Free!
Delete Grand Total rows and Outline Levels created in error,
and create Subtotals and Subtotal Outlines omitted in error.

Toggle between standard Excel subtotals and fixed subtotals.  Free!

Temporarly turn subtotals off and then back on.  Free!
Quick and easy way to work with data without subtotals getting in the way!

Toggle between subtotals below and subtotals above.  Free!

Toggle subtotal outlines between Excel's standard of one per defined subtotal
and EZ-Free's optimized outlines of one per break field.  Free!

Grouping subtotals by break field allows easier viewing of related subtotals and
effectively overcomes Excel's six subtotal outline limit by replacing it with a six break field limit!

Reset the Horizontal and Vertical Scroll Bars to eliminate empty scroll areas.  Free!
Columns to the right and rows below the data can be manually cleared to ensure they are empty.

Download EZ-Free

New!  EZ-Free includes 15-Day Trial of EZ-FindAll for Excel.


The EZ-FindAll Ribbon

EZ-FindAll group on the EZ-Free Ribbon.
15-Day EZ-FindAll Trial begins with first use of EZ-FindAll.



 


EZ-Split splits Excel Lists, Tables and Subtotaled Data
by selected values creating new identically formatted worksheets.
Splits retain formatting, totals and data to the right and below.
Split data for multiple selected values into one new worksheet.
Includes features for everyday Excel use, like Exporting the
visible rows of any worksheet retaining all formatting and
automatically converting formulas producing #REF errors to value.
Automates "Emailing" of split workbooks to save even more time!


The EZ-Split Excel 2007 / 2010 / 2013 Ribbon
Access the Identical Features from the EZ-Split Toolbar in Excel XP, 2000 and 2003.




Our Most Popular Add-in: EZ-Format for Microsoft ® Excel ®

Quickly Format Data Using Excel's Most Popular Features!
Create Reusable Formats for Completely Automatic Formatting!


EZ-Format includes free use of EZ-Split and EZ-Subtotal at no additional cost.

Mouse-over Ribbon for Tooltips and Click to
Watch "How-to" Video on Highlighted EZ-Format Feature.

After watching Video on YouTube, click "Back" (or Alt+"Left-Arrow") to return to this page.
Videos cover all versions of Excel.  Video Descriptions and Times are on the New EZ-Format Movie Page.

EZ-Format Menu - No Video EZ-Format Settings Menu - No Video Delete EZ-Format Formatted Worksheet Automatic 'Default' Formatting of New Data Sort and Subtotal Stats Menu - Quick Stats Video Format for Printing and Print Preview - No Video Standard Print Dialog - No Video Maintain Column Totals Turn Subtotals Off and On, and Remove Subtotals Export Visible Rows - No Video Split Sheet Menu - Split Worksheet Video View Excel Subtotal Outline Levels Select Reusable Worksheet Format Save / Delete Reusable Worksheet Formats - No Video Formula Field Menu - Add Formula Field Video EZ-Format's 8 Excel Style Features Create Excel Conditional Format Sort and Subtotal Field Order Rank / Resort Subtotaled Data Set Field Widths and Wrap Data Drag Reference Data to Subtotal Rows Hide Fields and View Hidden Fields Clear Data Filters and Show Non-Hidden Columns Show Data and Subtotals one Filter Value at a Time Select 'Full Stats' Break Field for Walking - No Video Bold and Shade Subtotal Rows View only Break, Subtotaled and Dragged Fields Filter Views Menu and Reapply Simple Data Filter - No Video Set Break Field 1 Subtotal Row Height

The EZ-Format Excel Toolbar
Click on Ribbon Options for Videos
Access the Identical Features from the EZ-Format Toolbar in Excel XP, 2000 and 2003.



 
Links to Product Pages and Free Trial Downloads
All Excel Add-ins Install and Completely Uninstall in Seconds.
 
 

NEW!

EZ-Free

Free
Forever!

Fix Excel created errors in "Grand Totals", final "Subtotals" and "Subtotal Outlines".
Double-click to quickly set and unset data filters in any filtered data.
Automatically exposes all related subtotals in subtotaled filtered data.
Expose subtotals for manually set filters in subtotaled data.
Turn subtotals temporarily off and then back on.
Toggle between subtotals below and subtotals above.
Toggle between up to six outlines for subtotals and up to six outlines for break fields.
Report all worksheets being used by / referenced in the current worksheet.
Optionally convert formulas and remove data validations referencing other worksheets.
Reset Horizontal and Vertical scroll bars to keep from scrolling into empty space.
Installation of the "Free Forever" EZ-Free includes the 15-Day Trial of EZ-FindAll.
Try


NEW!

EZ-FindAll

$19.95

Displays rows containing the search values along with additional user specified rows.
Searches can be either "And" (All Values) or "Or" (Any of the Values) for multiple values.
Temporarily hides rows "not" containing the "And" or "Or" search values.
Specify ranges of rows "never" to hide, guaranteeing titles, field names, descriptions,
     total rows ... always remain visible.
Sets the initial "Rows to Search" which can be subsequently modified.
Searches any set of user specified visible columns.
Searches can be either "Case Sensitive" or "Case Insensitive".
Searches for (a) exact matches, (b) contains, (c) starts with or (d) ends with.
Searches can be iterative when using "Export Visible Rows".
     Perform a new search on the results of the previous search.
"Clear Find" restores the worksheet to its' original state.
Use "Export Visible Rows" to create a new worksheet of any worksheet's visible rows.
Installation of the 15-Day EZ-FindAll Trail includes the "Free Forever" EZ-Free.
Try

EZ-Split

$39.95
Split tens-of-thousands of worksheet records to individual workbooks in seconds!
Split an Excel Worksheet to new worksheets for selected values in any field.
Split selected values to separate worksheets or to one combined worksheet.
New Split worksheets can be in one new workbook or multiple new workbooks.
Split All or Selected Sheets / Tabs in one workbook to new individual Workbooks.
Spread a Numeric Field to new Columns for each unique value in a non-numeric field.
Split combined Names into First, Middle, Last Names.  Fill Blank Cells from Cells Above.
New! Fix Subtotal formatting and split Subtotaled data retaining all formatting.
New! Selectively exclude columns from split worksheets / workbooks.
New! Email Workbooks to Embedded Addresses or Addresses by Field Value.
New! Supports the 32 bit and 64 bit versions of Excel 2010 and Excel 2013.
EZ-Split's three major Splitting functions are included free with EZ-Format.
Try


EZ-Format is the only Excel Add-in to Completely Automate Worksheet Formatting.
Go from raw data to an identically-formatted, feature-rich and printer-ready Excel worksheet in seconds.

EZ-Format

$49.95

Best
Value!

Quickly format data utilizing Excel's time-consuming major formatting features.
Create reusable worksheet formats for identically formatting new data in seconds.
Re-use formats to automatically and identically format data in a fraction of the time.
Use conditional formatting, sorting, better subtotaling & enhanced data analysis.
Filtered data exposes subtotal rows.  Export all visible rows in a single click.
Split Data & Totals to New Worksheets / Workbooks.  Automatically uses Excel Styles.
Mix subtotal types (sum count ... standard formulas) on bolded shaded subtotal rows.
Automatically recreate all User-Defined and 5 EZ-Format Custom Excel Formula Fields.
Includes many EZ-Split, EZ-Subtotal and EZ-Calc features, and all EZ-Stat features.
Visit the New EZ-Format Movie Page for over two dozen new "How-to" Videos.
New! Supports the 32 bit and 64 bit versions of Excel 2010.
Try


XL-Subtotal Completely Corrects / Fixes Excel Subtotaling Bugs for Free!
Fixes Multilevel Subtotals, Nested Subtotals, Subtotals in the wrong position / column.
Completely fixes Subtotals Below and Subtotals Above in a single click for FREE!

XL-Subtotal

$29.95

FREE
forever
Excel
Subtotal
Bug
Fix
without
Buying!

Fix Excel Bugs in Subtotals Above and Subtotals Below for FREE!
Double click filtered data to set and unset filters and expose appropriate subtotals.
Export the visible rows of filtered data retaining subtotals and outlines.
Switch between subtotals below and above, and temporarily turn subtotals off.
Switch between one outline level per subtotal and one outline level per Break field.
Bold and Shade subtotals for easier viewing.
Drag constant data in any field to the subtotal rows of the lowest break level.
Hide and unhilde fields that are not Break, Dragged or Subtotaled fields.
Save subtotal settings and reuse saved settings on different data for the same fields.
View and export subtotal data at any outline level hiding all empty data columns.
Export break field and subtotaled field data at any level to quickly create Charts.
Split Fixed Subtotaled data by values in any field using the EZ-Split add-in.
Supports the 32 bit and 64 bit versions of Excel 2010 and Excel 2013.
Try

EZ-ChartList

$14.95
Quickly chart Excel Lists, Tables and Subtotaled Data.
Make no modifications to the original List, Table or Subtotaled data.
Instantly switch charts between Count, Sum, Min, Max, Average and Std Dev.
Create both single and dual X-axis charts; for example Sum and Count values.
Save the chart format for subsequent re-use with new data.
Use EZ-ChartList for free with the purchase of EZ-Format.
Try

EZ-Importer
for PayPal


$9.95
Automatically accumulate only unique transactions from over-lapping PayPal exports.
Quickly and easily format and analyze transactions exported from PayPal to Excel.
Hide columns, total columns and filter columns for user-selected values.
Automatically update Excel PivotTables and PivotCharts for the latest PayPal data.
Try

EZ-Pivot

$39.95
Create automatically formatted Excel PivotTables, PivotCharts and Drill Worksheets
in seconds without modifying the original data's formatting.
Customize Drill Sheets: fields to display, field order, sort order, totals ...
Create Re-usable Custom Drill Worksheets for any PivotTable.
Use EZ-Format for even more options in automatically formatting Drill Worksheets.

Try

FlashVideo on EZ-Pivot
PivotTable, PivotChart and Drill Worksheet
Creation, Formatting and Analysis Tool