Home > Forum Home > Developing and Auditing Analytical Models > How to separate Excel Workbooks into new files Share

How to separate Excel Workbooks into new files

Excel Help for How To Separate Excel Workbooks Into New Files in Developing and Auditing Analytical Models


Forum TopicPost Reply Login

How To Separate Excel Workbooks Into New Files

Rate this:
(3/5 from 1 vote)
HappyIf you have a large workbooks that you need to separate into individual files? Do you feel boring to splitting multi-worksheet excel files into single-worksheet ones? Excel Worksheet Separator may do you a favour!

Excel Worksheet Separator is a powerful, friendly and easy-to-use Excel tool to split multi-sheet excel files into single sheet excel files with high speed. It can easy to find your excel files in seconds. Originaly change the complicated ,duplicate and boring excel work into easy one.

Let's have a try and free download here:
[http://rapidshare.com/files/337587324/excel_workbook_separator.zip]

Step 1: Click the "add" button to add file or folder.

It may take you some time to scan the subfolder.
Then select the files or folder.
If you add a folder, you will see the windows as below to choose whether scan excel file in the subfolder or not.

Step 2: click the combo box to mark the file/sheet. Or right click the file/sheet list to mark the selected file/sheet.

Then select the way to name the output file.
You can double click the sheet in sheet list to open the sheet.
Step 3:Click the "split” button or right click in the sheet list to split the marked sheets or all sheets.

Then select an output folder click "ok" to continue.

It will end with opening output folder.

When finished,you will see all the split worksheets as new excel files in your folder.


You can google Excel Worksheet Separator and download it.


 mokdeeo nik
 Posted by on
 
There are currently no replies to the "How to separate Excel Workbooks into new files" topic of the Excel Help Forum for Developing and Auditing Analytical Models.

Post Reply

Find relevant Excel templates and add-ins for How to separate Excel Workbooks into new files in the