| |
EZ-Split™
Worksheet Splitting
Add-in
for Microsoft®
Excel®
14-Day Trial
Purchase for $29.95
New Version 10/22/09
New! EZ-Format now includes EZ-Split & EZ-Subtotal
& all EZ-Stat features are built-in for use with EZ-Format worksheets.
Purchase EZ-Format for $39.95 and use EZ-Subtotal ($29.95) and EZ-Split ($29.95) free.
The advantage! EZ-Split retains all EZ-Format and EZ-Subtotal Formatting and Subtotals.
Download EZ-Format to try all three add-ins at the same time.
New! EZ-Split, EZ-Subtotal, EZ-Format & EZ-Stat Excel 2007 Ribbons
Every add-in's single install works with Excel 2000, XP, 2003 and Excel 2007
•
Split the Excel Data in one Worksheet,
for each selected value in any field,
into Separate Excel Worksheets, in either
One or Multiple New Excel Workbooks.
a.k.a. Splitting Excel Lists and Splitting Excel Worksheets.
New! Include all rows above the data in each split worksheet.
•
Extract Subsets of Data (Rows) from a Worksheet
by Selecting Multiple Unique Values in any Field.
•
Spread Values in a Numeric Field to New Columns
created for the Unique Values in a Second Field.
•
Split Name and Text Fields (Left, Center, Right).
•
Save All WorkSheets or Save Selected WorkSheets
(Tabs) to New Individual Workbooks.
•
Fill Blank Cells in One Column or in All Columns
from the Non-Blank Data Directly Above.
•
Merge Worksheets from Multiple Workbooks
into One New Combined Worksheet.
•
New! Splitting a Worksheet By Columns Retaining
All Worksheet & Print Formatting.
•
New! Copy / Export Visible Worksheet Row & Column
Data to a New Workbook retaining All Formatting.
•
Completely Learn within Minutes of Installing.
EZ-Split's Splitting
Worksheet Data
for Selected Values
|
EZ-Format Completely
Automatic Worksheet
Formatting
|
EZ-Format's Copy
Only Visible
Worksheet Data
|
EZ-Format's Better
Formatted Subtotals
|
Download EZ-Split 14-Day Trial
All Add-ins Install and Completely Uninstall in Seconds
All Add-ins include Free Lifetime Updates and Enhancements
Use with Excel® 2000, XP, 2003 and 2007
on Microsoft® Windows® 2000, XP and Windows Vista®
Click the Flash Video Links to see EZ-Split's major features.
EZ-Split Features
|
Worksheet
Splitting
|
Split All Data or only Visible Data (Rows & Columns) into individual Worksheets for Selected Values in one Field.
Split Sheets can be combined into One New Workbook or separated into Multiple New Workbooks.
Automatically recreate EZ-Format and Xcelerator created Subtotals.
New! Include all rows above the data in each split worksheet.
|
|
Workbook
Splitting
|
Split All Sheets or Only Selected Sheets in one Workbook into Multiple New saved Workbooks each containing only one Sheet.
|
|
Worksheet
Subsetting
|
Split Data in One Worksheet into another New Worksheet for all Selected Values in one Field (any subset of values).
Optionally create individual sheets for each selected value.
The identical feature is available in EZ-Calc.
|
|
Spreading Numeric Fields
|
Spread numeric values in one field to new columns for unque values in another specified field.
For example, spread Sales to new columns for each Salesman.
The identical feature is available in EZ-Calc.
|
|
Text and
Name Field
Splitting
|
Split or Extract Text from one Column into a new automatic Column.
Split Text can be on the Left, Center or Right, and separated from the other text by any single character.
A more powerful version of this feature is available in EZ-Calc.
|
|
Filling
Blank Cells
|
Fill blank cells with the data from the cell above for only the selected column or for all columns.
|
|
Merging
Worksheets
|
Merge worksheets containing identical fields from a single workbook or from multiple workbooks into a single new worksheet.
|
|
New!
Splitting
By Columns
|
Specify the constant columns to appear on the left of each split, the complete range of columns to be split beyond the constant columns, the number of columns in each split group, and the row containing the description for the new Tab Name and new Workbook Name of each split. All worksheet and print formatting is retained in each new worksheet of split columns.
|
|
New!
Copying
Visible Data
|
Copy or Export only the Visible Rows and Columns of Data in one worksheet to a new Workbook retaining all worksheet and print formatting.
|
|
Example of EZ-Format formatted State and City Subtotaled Worksheet Split by 'Name'
with shaded and bolded subtotals mixing a Count, two Sums and one Excel Formula.
Use EZ-Split to split Excel Worksheets and to split Excel Lists beginning in Cell A1.
EZ-Split Add-in for Microsoft Excel Features
Split Excel Worksheets for only Selected Data Values.
Split Excel Data using any non-numeric data column.
Split Worksheets are Identically Formatted.
Page Formatting is retained in each split worksheet.
Exclude Hidden Rows when Splitting an Excel Worksheet.
Convert formulas to values when Splitting Excel Lists.
NEW! Include All Rows Above Data in Each New Worksheet.
Create Split Worksheets in one new Workbook.
Split Worksheet tab names match the split data value.
Create Split Worksheets in multiple new Workbooks.
Split Workbook names match the split data value.
Column Totals are retained when splitting an Excel List.
Subtotals are re-created when splitting a subtotaled worksheet created by EZ-Subtotal, EZ-Format and Xcelerator.
NEW! Split a Worksheet by Columns by specifying:
(1) the common set of columns for each new worksheet,
(2) the starting column of the variable columns,
(3) the number of variable columns in each grouping, and
(4) the row number containing the description to be used for the new worksheet and workbook names.
Spread the Values in a Numeric Field to New Columns created for the Unique Values in a Non-numeric Field.
Specify a Separator Character(s) and Split or Extract the Left, Center or Right portions of a Name or Text Field.
Fill in missing data when splitting an Excel List.
Fill blank cells in the Split Column as part of Splitting.
Fill in blank cells before ever Splitting Worksheet Data.
Blank cells are filled from the above non-blank cell.
Fill cells in either one column or in all columns.
Merge worksheets containing the identical fields.
NEW! Export or Copy only the Visible Rows and Columns in one Worksheet to a new Workbook retaining all Formatting.
|
EZ-Split Menu on EZ-Split Toolbar
EZ-Split's "S" Pop-Click Menu on EZ-Split Toolbar
EZ-Split Dialog used to create new Split Workbook above from worksheet below
Use "Split Selected Sheets to New Workbooks" to create individual Workbooks
for Split Worksheets initially created in one Workbook, not indiviual Workbooks.
Example of EZ-Format formatted State and City Subtotaled Worksheet prior to Splitting.
Bolding, Shading, Mixing Subtotal Types and Formulas are not standard Excel features.
EZ-Format and Xcelerator created subtotals are re-created in Split Worksheets.
EZ-Split is included Free with EZ-Format and Xcelerator.
Dialog for Prefix Name when Saving Selected Sheets to New Individual Workbooks
Use 'Control+Left-Click' and 'Shift+Left-Click' to Select Sheets to Copy to New Workbooks.
Dialog for Selecting Values for Copying Subsets of Data to Worksheet in New Workbook
Checking 'Separate Tabs' also creates individual worksheets for each selected value.
NEW! Dialog for "Splitting a Worksheet By Columns" into worksheets in one New Workbook
Use "Split Selected Sheets to New Workbooks" to create Workbooks for Split Column Worksheets.
Dialog for Spreading a Numeric Field to New Columns for Unique Values in Second Field
Worksheet after Spreading 'Sales Amt' by the Unique Values in 'Trans Code'
Dialog for Splitting 'Name' or Text Fields to New Fields
Worksheet after Splitting 'Name" Field into
'First Name', 'Middle Name' and 'Last Name' using EZ-Split
Fill Blanks in a Selected Column or All Columns using EZ-Split
Filling Blank Cells is necessary before working with data where duplicates are removed.
Merge into a new Worksheet all the Worksheets in all the Workbooks in the selected Folder containing the identical Fields as the active worksheet of the selected Workbook.
The fields in the active sheet of the selected workbook determine the matching worksheets.
Try EZ-Split Free for 14-Days - Purchase for $29.95
Download EZ-Split
and install standalone to demo all features.
Use EZ-Split Free with these two Add-ins
EZ-Split is included in the installs of each of these Add-ins
Download
EZ-Format
Download
Xcelerator
EZ-Split's Separate Toolbar in EZ-Format and Xcelerator
|
|
|
|
|
PRODUCTS