Quickly Split Worksheets into Multiple Workbooks in Excel 2007/2010

In Microsoft Excel 2007/2010, one worksheet can be saved as a workbook only if we copy and paste this worksheet into a new workbook. It seems troublesome if you want to split a large workbook. Kutools for Excel’s Split Workbook tool can:

1. Quickly split all worksheets of a large workbook into individual workbook;Demo
2. Support "Skip hidden worksheets" and “Skip blank worksheets”;
3. All new generated workbooks keep all formats of original worksheet, including the Row Height and Column Width.

Click "Kutools">> "Workbook Tools" >> "Split Workbook". See screenshot (Fig.1).

Fig. 1: Split Workbook tool in Kutools for Excel

Usage:

1. Activate the workbook you want to split.
2. Get into "Split Workbook" dialog box, and select worksheets that need to be split, and then click "Split" button.
3. In the popup "Browse for Folder" dialog box, specify the location for these split workbooks.

Notes:

1. "Skip Hidden Worksheets" option: with this option, users are not necessary to worry about that hidden worksheets will be split into new workbooks even users have selected these hidden worksheets in the Worksheet Name list.
2. "Skip blank Worksheets" options: with this option, users are not necessary to worry about that blank worksheets will be split into workbooks even users have selected these blank worksheets in the Worksheet Name list.

See Split Workbook feature demo (Video 1).

This is only one feature of Kutools for Excel

It includes more than 100 functions and tools for Excel 2007 and 2010.