Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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.

Easily Combine multiple sheets/Workbook into one Single sheet or Workbook

To combinne multiples sheets or workbooks into one sheet or workbook may be edious in Excel, but with the Combine function in Kutools for Excel, you can combine merge dozens of sheets/workbooks into one sheet or workbook, also, you can consolidate the sheets into one by several clicks only.  Click for full-featured 60 days free trial!
combine sheets
 
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 60 days.

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.

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.

Notes:

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 functions, makes your jobs easier. 

After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)

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:
doc combine 1

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.

arrow blue right bubble Combine multiple sheets into one sheet or one workbook




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.

After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)

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.

arrow blue right bubble insert a workbook file into a cell




Tabbed browsing & editing multiple Excel workbooks/Word documents as Firefox, Chrome, Internet Explore 10!

You may be familiar to view multiple webpages in Firefox/Chrome/IE, and switch between them by clicking corresponding tabs easily. Here, Office Tab supports similar processing, which allow you to browse multiple Excel workbooks or Word documents in one Excel window or Word window, and easily switch between them by clicking their tabs. Click for free 45-day trial of Office Tab!

ot excel


Recommended Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 70%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 80% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
 
 
 
 
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    manjunath.n.gowda · 4 years ago
    hi
    I want add my two worksheet into all my existing excel file. Pl help
  • To post as a guest, your comment is unpublished.
    rajk · 4 years ago
    Dear Sir,

    thanks for great article about Excel
    I am a student & want to learn more about Excel features of Kutools for Excel but it available for only 30 days cant you provide student version in this utility.