How to insert worksheets from another workbook?

Sometimes you may need to import worksheets from other workbooks. If you copy the worksheets' content and paste to current workbook, it loses some formatting styles, such as row height, etc. This article describes some handy ways to insert worksheets from other workbooks quickly with losing data and formatting styles.

good idea4Combine Worksheets

Kutools for Excel's Combine Worksheets function can combine multiple sheets from workbooks into one workbook or one worksheets, also can consolidate and calcualte values across workbooks into one.
To Get Free Trial Now!                                                          Know more about this utility
Apply Enterprise > Combine to quickly combine multiple worksheets inton one worksheet or workbook.
doc combine

arrow blue right bubble Insert worksheet from other workbooks with Move or Copy command

The Move or Copy command can help you insert worksheets from another workbook easily.

formula Never need to worry about long long formulas in Excel anymore! Kutools for Excel's Auto Text can add all formulas to a group
as auto text, and liberate your brain! Click here to know Auto Text     Click here to get free trial

Step 1: Open all workbooks that you will work with.

Step 2: Active the workbook containing the worksheet that you will copy.

Step 3: Select the worksheets that you want to copy.

You can select multiple worksheets by holding down Ctrl key or shift key.

Step 4: Right click the selected worksheet, and click Move or Copy from contend menu.

Step 5: In Move or Copy dialog box, select the workbook that you will copy selected worksheets to in the drop down list Move selected sheets of To Book:, and check the Create a copy option.

Step 6: Click OK.

Then you will see the selected worksheets are copied and inserted to the workbook that you specified in Step 5.


1. You must open all workbooks that you will work with, including the workbooks containing needed worksheets, and the workbook you will insert the worksheets to. Otherwise, you will not find out the workbook names in Step 5.

2. You must check the Create a copy option in Move or Copy dialog box, otherwise you will move the selected worksheet out of original workbook.

arrow blue right bubble Insert worksheet from other workbooks with Combine of Kutools for Excel

The second trick, the Combine utility of Kutools for Excel, will simplify you work to insert worksheets from many workbooks without opening all of them.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

After free installing Kutools for Excel, please do as below:

Step 1: Click the Enterprise > Combine, see screenshot:

Step 2: In the Combine Worksheets dialog box, you may check one of the combine operation from the options. Here we take the third option for example, then click Next. See screenshot:

Step 3: You can add workbooks by clicking Add button or Scenario button. And then you can specify which worksheets you want to insert from the added workbooks in the right box. Also, you can rearrange the order of the workbooks and worksheets. (By default, all worksheets are selected in the Worksheet list.)

Step 4. You can rename the worksheet name and specify the Separator in the Combine Worksheet –Step 3 of 3 dialog. And also when you encounter blank worksheet, you can choose skip or keep it in the drop-down box. Finally, click Finish. See screenshot:

Then you will see all selected the worksheets are inserted into current workbook quickly. The first worksheet named Kutools will be a sheet list the detail information of each inserted worksheet. See screenshot:

Moreover, the utility of Combine also can combine worksheets into one worksheet, combine the same name worksheets into one worksheet and consolidate values across workbooks into one worksheet.Click to know more about this Merge Workbooks utility of Kutools for Excel.

Get Free Trial of Combine

arrow blue right bubble (4 steps) Insert worksheet from other workbooks with Insert File at Cursor of Kutools for Excel

If you just want to insert a worksheet from another workbook into the current worksheet, you can use Kutools for Excel’s Insert File at Cursor utility if you have installed Kutools for Excel.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

After free installing Kutools for Excel, please do as below:

After installing Kutools for Excel, please do as below steps:

1. Click at a cell you want to place the worksheet content at.

2. Then click Enterprise > Import/Export > Insert File at Cursor. See screenshot:

doc insert sheet kte 1

3. In the Insert File at Cursor dialog, click Browse to select the workbook you need to insert from, then you can check Values only (no formulas) or Do not transfer formatting options as you need. See screenshot:

doc insert sheet kte 2

Values only (no formulas): Insert displaying values only.

Do not transfer formatting: Keep the cell format after inserting worksheet

4. Click Ok, now a dialog pops out for selecting a sheet you need to insert. Then click Ok.

Now the worksheet contents have been inserted to the current worksheet.

Click here to know more about Insert File at Cursor.

pay attention1If you are interested in this addi-in, click here to download the 60-days free trial.

good idea Combine Columns or Rows

Kutools'Combine Columns or Rows function can quickly combine multuple cells based on row/column and separated by comma or space, or combine
a range of cells into a single cell with specific separator.
Free Install and Free Trial                                                                                   More about this utility
Apply Kutools > Combine to combine cells without losing data.
doc combine cells (1.)Select Select Combine columns under To combine selected
cells according to following options

(2.)Specify a separator for the combined data, here I select Space;

(3.))Specify the cell you want to place your combined result;

(4.)Specify how you want to deal with the combined cells.

doc KTE

Relative articles:

Is your problem solved?

Recommended Productivity Tools

The following tools will greatly save your time and effort, which one do you prefer?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: 120 powerful new functions for Excel, Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 More than 120 powerful advanced functions which designed for Excel:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase

Add comment

Security code