This tutorial shows how to move or copy a worksheet from one workbook to another.
There could be many reasons when we need to copy or move a worksheet from one workbook and paste it into another one.
Like having multiple formats and formulas in a worksheet.
And it may take a huge amount of time to apply the same formatting and formulas into another workbook.
The good news is Excel has a feature that can help to move or copy the whole worksheet from one workbook to another.
Here we have 3 different ways to move the whole worksheet from one workbook to another.
Suppose that we have a workbook named “Practice Files” and this workbook has 3 different sheets “Data1”, “Data2”, and “Data3”. See in the image below:-
Now we want to move anyone sheet from these 3 sheets into another workbook, which may be any new workbook named “Book1” or any previously saved one.
It depends upon your requirements.
Now suppose that we want to copy or move worksheet “Data2” from ‘Practice Files” to the new workbook “Book1”.
Here we have 3 different methods to do this task.
Our new workbook “Book1” has 3 sheets by default.
Now the task is to move the worksheet from “Practice Files” to “Book1” at the end of all the sheets.
In Book1 we have 3 worksheets, which means we will move the sheet after sheet3.
Move or Copy a Worksheet Without Create a Copy
This method will move the worksheet completely and will not create a copy.
To apply this method, use the following procedure step by step.
First, to have both workbooks in one place side by side will help to do the task easily.
Then select the desired sheet which you want to drag to the new workbook.
Pick it up from the mouse keep pressing the left button and do not leave it until you drag it into its destination place.
See the image below:-
A worksheet has moved from its original location to the end of all worksheets in a new workbook.
This method will remove the worksheet from its place.
Move or Copy a Worksheet With Create a Copy
This is another method to move or copy the worksheet from one workbook to another.
This method will create a copy of the worksheet which we want to move into another workbook.
First, align both the workbook accordingly so it will be easy to drag to the next workbook.
For dragging the worksheet from one place to another.
First, select the worksheet.
For dragging sheets, just select the worksheet then pick it from the mouse (use CTRL key from keyboard) and drag it to the destination place or next workbook.
Here drag the “Data2” sheet and move to the next workbook “Book1”.
See that worksheet “Data2” is copied to the next workbook and the original worksheet “Data2” is remaining in its original location.
Keep in mind that we will keep pressing the CTRL key to create a copy, while dragging from one workbook to another.
Move or Copy the Worksheet into Another Workbook
This one is the third method, here first of all select the worksheet which we want to transfer or copy to the next place.
Now here we will use the mouse again to execute the task.
Right-click from the mouse on the desired sheet, and select the option “Move or Copy” here from the listed options see image below:-
Once you click on this option, you will get the following image.
Here in this image, there are some options, which we need to know.
- Filename (Practice Files), from which you want to transfer worksheet
- All the worksheets appear here in this workbook.
- Drop-drop arrow, here all the opened workbooks are listed.
Now if you click on the no. 3, drop-down here, it will show you all the open workbooks.
Then you can select the destination workbook, where you want to move or transfer our worksheet.
Click on this drop-down arrow and select the new workbook “Book1” from here.
This will display all the worksheets of this workbook.
See the image below:-
When you will select workbook “Book1” from the drop-down list.
You will see that all the worksheet are appearing at the below area.
- Before Sheet: – Select the sheet number here, before which you want to drag it.
- Move to end: – select this, if you want to move the sheet at the end of all worksheets.
- Create a Copy
- (a) – If you want to create a backup copy then tick it
- (b) – Otherwise leave this blank
Now use this dialogue box to get the things done.
Select the workbook “Book1” to move or copy our worksheet.
Then click on the ‘move to end’ option, this action will drag your worksheet to the end of all the worksheets in the destination workbook.
Click on the check box at the bottom to create a copy of the worksheet.
And click “Ok”.
See in the below image, the worksheet is the move to the new workbook, and sheet “Data2” still exists in the original workbook also.
So we have used here multiple ways to transfer the worksheet from one workbook to another with or without creating a backup copy.
So these are the three easiest methods to copy or move a worksheet from one workbook to another.
If you want to learn more about this, please visit Microsoft Office Support.
I hope you find this tutorial useful.
Please feel free to put your comments or suggestion in the comment box below.
How to Remove Formulas and Keep the Values in Excel (4 Quick Ways)