`
Join In
Useful Tools
Split workbook
Tools       2020/6/9 9:50:31          Author: FFCell
Views: 0

If we want to split each worksheet as an individual workbook , it is the right choice to use this feature: Split workbook.


For example, we want to split each worksheet from below two workbooks as an individual workbook.(there are total 4 worksheets in below 2 workbooks)


We choose the feature Split workbook in Split group, and then click Start button (upper right corner).


Step 1: Select excel files

We drag those two excel files and drop them to the blank area, and then click Next button.


Step 2: Select worksheets

All sheets means all sheets in the selected excel files will partcipate in split.

If we only want the first sheet in selected excel file to participate, we can choose the next option and set it as :

Sheet 1 to 1 from left to right


If we want the specific sheets in the selected excel files to participate in split, for example the sheet Februray, pls choose this option:Specific sheets (MultiSelect)

And we will get all sheets' names from the first excel file by default, and then tick the specific sheet (sheet Februrary) you want.


If the first excel file does not include sheet February, we can click Get All , and then we will get all sheets' names from all selected excel files. But it will take a long time.

It is better for us to click the Input button and then input the sheet name manually.

If we don't want the hidden sheets or blank sheets to participate in the split, pls tick Skip hidden sheets and Skip blank sheets. In Step 2, we decide to choose All sheets, and then click Next button.


Step 3: Save options

In this step, we have 3 parts to set: New workbook name, Save path and Advanced options.


In the part of New workbook name, we can use Naming convention to name the new workbook automatically by clicking the button on the right end. What is Naming convention? How to use it? Pls click here.

As to the File type, we can choose xlsx or xls.


In the part of Save path, we can click Browse button to change the save path of the result workbooks if we do not like the default save path.


In the part of Advanced options, Data numeralization means to change all formulas into values and remove all hidden ranges after split. We can tick it if need.And then click Next button.


Step 4: Ready to split



Click Start button, and some seconds later, split completed.


Finally, we get a folder in which there are 4 new individual workbooks. We are successful to split each worksheet as an individual workbook. Let's open it and take a look.