How to Insert Worksheet in Excel From Another Workbook
Anyone who works with Microsoft Excel knows how powerful this application is. Besides being able to handle a large amount of data and store innumerable information in an organized way, it can also perform small calculations quickly.
One Excel workbook can contain many worksheets or spreadsheets. Sometimes, you need to move one worksheet from a workbook to another one. If you don’t know the best methods to do so, you will end up spending your valuable time. Read on to know how to insert worksheet in Excel from another workbook.
How to Insert Worksheet in Excel From Another Workbook
There are two different methods to insert a worksheet in Excel from another workbook. These are:
Method 1
- Open all the workbooks necessary for this worksheet copy. These should be the source workbook containing the sheet you want to insert and the target workbook where you will move it.
- First of all, go to the source workbook and open the sheet you want to insert.
- At the bottom, you will see all the sheets of the workbook listed and the current sheet selected. Right-click on the tab and choose the Move Or Copy option from the menu.
- Next, you will get a list of target workbooks under the To book option. Select your workbook where you want to insert it. You can also select the placement of the newly inserted sheet.
- By default, Excel moves the sheet instead of copying it. So, if you want to insert the sheet while keeping a copy to its original workbook, you need to check mark the box Create a copy.
- Finally, click on OK and Excel will insert the worksheet in no time.
Method 2
- Open both the required worksheets and go to any one of them. Select the View tab and click on the option View Side By Side located in the Window group.
- Both Excel files or workbooks will appear on the screen horizontally.
- Put your cursor on the tab of your chosen worksheet and drag it to the destination workbook. If you have only one sheet in the source file, this method will not work and you need to apply Method 1.
- To copy the sheet instead of moving it, you have to press down the Ctrl key while dragging.
Note: Now that you know how to insert worksheet in Excel from another workbook, you should be aware of associated issues before applying the methods. Even if you do not face any trouble during the worksheet import, some issues might appear later.
For example, some worksheets contain processes that refer to another worksheet of the source file. While Excel offers maximum effort to locate the source workbook, it may fail to do so. In that case, users will get errors while running the process.
Conclusion
Inserting one Excel worksheet from another workbook might seem a challenging task to you, but that is not the case. Here, we described how to insert worksheet in Excel from another workbook using two methods.
As the approaches have been explained step-by-step, you should follow any of these and get your job done without any difficulty. Additionally, if you are dealing with multiple worksheets on your Excel workbook, follow our tutorial to set a default sheet in Excel.
