NEW! XL-Subtotal Fixes Excel's Subtotaling Bugs! The only solution to completely correct Excel Subtotal Bugs in one click! GET the FREE Forever Subtotaling Bug Fix Now!
Fixes Multilevel Subtotals, Nested Subtotals, Subtotals in wrong Position / Column / Order, Incorrect Subtotal Outlines, Missing / Erroneous Grand Totals in Subtotals Above and Below.
The Subtotal "FIX" Feature on the Excel Ribbon and Excel Toolbar is FREE forever. After the Trial, purchase for $19.95 to keep using dozens of Subtotaling enhancements.
The Free Excel Subtotal Fix in XL-Subtotal benefits everyone using Excel Subtotals!
Split worksheet data in Excel Lists and Excel Tables by the values in any field, creating new worksheets in seconds! Retain Print, Worksheet and Table formatting, List Totals, Table Totals, Custom Totals, the Freeze Pane, Data Filters, data outside the List and Table, and EZ-Format Subtotals.
New! Split Excel Tables retain the table design, all table totals and data below and to the right of the Table.
Create split worksheets in one new workbook or individual new workbooks for each split value.
Copy all sheets or selected sheets in any workbook to new individual workbooks.
Export visible data in any worksheet to a new worksheet converting formula cells producing #REF errors to value.
New! When splitting worksheet data selectively exclude List columns and Table columns from the split worksheets.
New! Use free EZ-Email to automatically Email Excel Workbooks to 'Embedded' and 'Linked' Addresses.
New! Includes 32 bit and 64 bit versions for Excel 2010.
Coming! Quickly set and unset Excel data filters by double-clicking values in any filtered data.
The identical features are included in EZ-Format for Excel.
Installs and Completely Uninstalls in Seconds. Securely Purchase from inside Excel.
Use with Excel 2000, XP, 2003, 2007 & 2010 on Windows® 2000, XP, Vista® & Windows 7®.
We recommend running Windows Update for Windows and Office® before installing EZ-Split.
New! EZ-Format includes: EZ-Split's Worksheet and Workbook Splitting, EZ-Subtotal's Subtotaling, six EZ-Calc Formula Fields, all EZ-Stat features and Reusable Worksheet Formats.
Mouse-over Menu for Tooltips and Click to Watch "How-to" Video on Highlighted EZ-Split / EZ-Format Splitting Feature.
After watching Video on YouTube, click "Back" (or Alt+"Left-Arrow") to return to this page.
View the identical Videos from either Splitting Menu.
All Add-ins Install and Completely Uninstall in Seconds All Add-ins include Free Updates and Enhancements Use with Excel® 2000, XP, 2003, 2007 and 2010 on Microsoft® Windows® 2000, XP, Vista®; and Windows 7®
Click the Flash Video Links to see EZ-Split's major features.
Split visible Data Rows into individual Worksheets for Selected Values in any 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! Retains rows above and below the data in the split worksheets. New! Copies worksheets referenced in Formulas to Split Workbooks. New! Optionally excludes selected columns from Split Workbooks.
New! Workbook Emailing
Use EZ-Email to email selected Workbooks to either 'Embedded' or 'Linked' email addresses through Microsoft Outlook from inside Excel.
Split All Sheets or Only Selected Sheets in one Workbook into Multiple New saved Workbooks each containing only one Sheet.
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.
Merge worksheets containing identical fields from a single workbook or from multiple workbooks into a single new worksheet.
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 of Data in one worksheet to a new Workbook retaining all worksheet and print formatting.
How to! Splitting to a Specified Number of Worksheets
To Split one worksheet into a user-specified number of new worksheets add a "Group" field and split by the values in this new field. Click for Simple Instructions.
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 Worksheet by any Data Column in an Excel List.
Split Excel Data for only Selected Data Values.
Split Worksheets are Identically Formatted.
Page Formatting is retained in Split Worksheets.
Automatically Exclude Hidden Rows from Split Worksheets.
Optionally Convert Formulas to Values in Split Worksheets.
NEW! Retain Rows Above and Below List Data being Split.
NEW! Exclude Selected Columns from Split Worksheets.
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.
How to Split one Worksheet into an Exact Specified Number of Workbooks.
List data should begin in cell A1 and include unique Field Descriptions.
Determine total number of split worksheets to be created; i.e 20.
Determine total number of data records to be split; i.e. 110. Take the last data row number (111) minus 1 to exclude the field description row.
Divide total data records by total split worksheets rounding up to calculate the number of records in each new workbook. 110 / 20 = 5.5 = 6 rounded up.
Insert a New Column into the List as Column "A".
Assign a Field Description to Column "A" such as "Group".
Create this formula in row two and copy to all other data rows: =Roundup(Row()-1/6,0) copied from row 2 through row 111. Row() is the Excel function that returns the current row number. The -1 from Row() ensures 6 records in the first group. The denominator, or 6, is the number of records in each group. The 0 parameter specifies displaying zero decimal positions.
Copy and then Paste Special using the Convert to Value Option. Select cell A2 through the last data row in Column A for copying. Paste Special / Converting to Value over the selection in Column A. Converting to Value keeps the Group Values from being recalculated as "1" in the new Split Worksheets.
Use EZ-Split's Single Value Splitting and Split by the "Group" field.
Use EZ-Split's "Merge" feature to recombine the Split Worksheets after they have been updated.
EZ-Split will recreate column totals in the Split Worksheets. In the Original Worksheet separate column totals from the data by one totally blank row. Use =Subtotal(9,cell range) for Sum Totals that adjust with Filters. Use =Subtotal(3,cell range) for Count Totals that adjust with Filters. Data Filters in the Original Data will be recreated in the Split Data. A Freeze Pane in the Original Data will be recreated in the Split Worksheets. Print Formatting in the Original Worksheet will be recreated in the Split Worksheets.
EZ-Split Menu on EZ-Split Toolbar in Excel 2000, XP and 2003
EZ-Split's "S" Pop-Click Menu on EZ-Split Toolbar in Excel 2000, XP and 2003
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 and Mixing Subtotal Types are not standard Excel Subtotaling features. EZ-Format and Xcelerator created subtotals are re-created in Split Worksheets.
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.
emails Workbooks to 'Embedded' and 'Lookup' Addresses in both EZ-Split and EZ-Format
Try EZ-Split Free for 15-Days - Purchase for $39.95