Quickly copy or insert multiple worksheets in Excel 2007/2010

Quickly Copy or Insert Multiple Worksheets in Excel 2007/2010

It’s quite easy to copy or insert one worksheet in Excel, but if you want to copy or insert multiple worksheets in a workbook, you might need to spend some time in several mouse clicks, because Excel does not support an option to quickly copy or insert multiple worksheets. For example, if you need to insert 30 worksheets in workbook, you have to click the “Insert Worksheet” or press (Shift+F11) 30 times. Or when you want 10 copies of the active worksheet, you have to right-click the sheet tab and make the copy one by one for 10 times. That’s a really time-consuming operation. Kutools for Excel’s Copy/New Multiple Worksheets tool can consolidate the performance and eventually save your time by bringing the following handy operations: Demo

Batch making multiple copies of the active worksheet;
Batch inserting multiple new worksheets in the workbook.

Click "Kutools">>"Worksheets Tools">>"Copy/New Multiple Worksheets". See screenshots (Fig.1 and Fig.2).


Fig.1 Copy/New Multiple Worksheets		Fig.2 Copy/New Multiple Worksheets windows

Usage:

1. Click to choose “New” or “Copy” worksheets;

2. Directly input number or select a range of cells to specify the quantities of the new/copied sheets

3. Specify where to insert or copy worksheets (after/in front of the active worksheet);

4. Click “OK” to finish the operation .

Let us look at the following example. There are 8 sheets in the workbook, and I want to insert 3 new sheets after the “May” sheet with the names specialized in the range (See Screenshot Fig. 3). By using the Copy/New Multiple Worksheets, select the range, and then the new sheets are quickly created (See Screenshot Fig. 4).


Fig.3 Insert New Multiple Worksheets		Fig.4 After Inserting New Multiple Worksheets

The quantity of the new/copied sheets can be specified by:

Input number as quantity of the new/copied sheets, while the sheets are named by default;

The quantity and names of the new/copied sheets can be specified from selected range.*

*Note: If using the data in the selected range to copy or insert sheets, then the quantity and name of the new/copied sheets are specified based on the data. The data of the selected range should be valid to name a worksheet. Those data (containing excessive 31 characters or special characters like *, /,?...) cannot be used as sheet name.

See Copy/New Sheets feature demo (video 1)

Video 1. Copy/New Sheets feature demo.