How to separate Excel Workbooks into new files


 

Current User: Guest Login Register
Please consider registering

Search Forums:


 






How to separate Excel Workbooks into new files

Add a New Topic Reply to Post
UserPost

3:32 am
February 3, 2010


mokdeeo

New Member

posts 1

If 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://www.excelpedia.com/

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

http://www.excelpedia.com/images/step-by-step_clip_image002.jpg
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.

http://www.excelpedia.com/images/step-by-step_clip_image002_0000.jpg

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

click the file/sheet list to mark the selected file/sheet.

http://www.excelpedia.com/images/step-by-step_clip_image002_0001.jpg

http://www.excelpedia.com/images/step-by-step_clip_image002_0002.jpg
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.

http://www.excelpedia.com/images/step-by-step_clip_image002_0003.jpg

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

It will end with opening output folder.
http://www.excelpedia.com/images/step-by-step_clip_image002_0005.jpg

When finished,you will see all the split worksheets as new

excel files in your folder.

http://fc03.deviantart.com/fs45/f/2009/123/6/1/rainbowsheep2_by_RainbowSheep2.gif

Reply to Post


Reply to Topic:
How to separate Excel Workbooks into new files

Guest Name (Required):

Guest Email (Required):

NOTE: New Posts are subject to administrator approval before being displayed

Smileys
Confused Cool Cry Embarassed Frown Kiss Laugh Smile Surprised Wink Yell
Post New Reply

Guest URL (required)

Math Required!
What is the sum of:
4 + 10
   



About the InternetOfficer.com forum

Most Users Ever Online:

65


Currently Online:

11 Guests

Forum Stats:

Groups: 2

Forums: 7

Topics: 318

Posts: 1557

Membership:

There are 165 Members

There have been 181 Guests

There is 1 Admin

There is 1 Moderator

Top Posters:

cssfsu – 31

albert_newton – 30

x-plicit2009 – 14

Steve – 14

flwg – 12

dumpuse – 10

Administrators: Jean-Luc (688 Posts)

Moderators: Jean-Luc (688 Posts)