Copy Excel Sheet (Table of Contents)
Copy Sheet in Excel
There are 2 ways to copy any worksheet. By the first way, click right on the name of any Sheet name tab and then select the Move Or Copy option from the right-click menu list. Then from Move Or Copy box, check the box of Create A Copy with tick and press Ok to proceed for creating a copy of that sheet. In a second way, select the sheet which we want to copy, then process Ctrl and drag that sheet on Plus sign located beside the sheet name. This will create a copy of the selected sheet keeping the word COPY in the brackets.
There are multiple ways where we can do this task.
- Move Sheet within the same workbook: This will move the worksheet to the end or the start in the same workbook.
- Copy Sheet within the same workbook: This will create a carbon copy of the same worksheet.
- Move Sheet to Another workbook: This will move the worksheet from one workbook to another workbook. If you move, it will move the sheet to new workbook but will disappear from the existing worksheet.
- Copy Sheet to Another workbook: This will copy the worksheet from one workbook to another workbook with the copy of the existing worksheet.
How to Copy an Excel Sheet?
Copy Excel Sheet is very simple and easy to use. Let’s understand the working of copying excel sheet by using some different methods.
Method #1 – Move Sheet within the same workbook
If you want to move the active sheet to the end of the worksheet you can apply this method. Look at the below image I have total 3 worksheets.
Right now Sheet 1 is at the beginning of all the worksheet. I want to move this sheet to the end of the works sheet.
- Right-click on Sheet 1 and select Move or Copy
The shortcut key to open Move or Copy is Alt + E + M.
4.9 (6,356 ratings)
View Course
- Once you click on Move or Copy, it will show you a new window. In the new window select (move to end).
- This will move this sheet to the end.
Method #2 – Copy Sheet within the same workbook
If you want to create a copy or the replica of the existing worksheet in the same workbook we can apply this method.
I will take the same workbook here as well. I want to create a replica of Sheet 1.
- Right click on Sheet 1 and select Move or Copy.
- Once you click on Move or Copy it will show you the new window. In the new window select Sheet 1 & check the box create a copy and then click on OK.
- It will create a copy of the worksheet for you. The new sheet will be the same as the existing worksheet with (2) in front of it.
Method #3 – Move Sheet to Another workbook
If you want to move the entire worksheet to new workbook you can apply this method. For this, we need a minimum of two workbooks to be opened. My two workbook names are Worksheet 1 and Worksheet 2.
I have opened both the worksheets at this point in time. In the workbook Worksheet 2, I have sheet name called Data Sheet and I want to move this worksheet to another workbook called Worksheet 1.
- Right click on the sheet you want to move and select Move or Copy.
- Once you select this option it will show you the new window.
- In this window, there is a drop down called To book. Click on this drop-down. It will show you all the opened workbooks, select the workbook which you want to move. I have selected the workbook called Worksheet 1. I am not going to create a copy of the worksheet but I am just moving it to another workbook.
- Once you select the new workbook name it will show you that workbook’s worksheets. Select the option of (move to end). Click on OK to complete the process.
- It also deletes the sheet in the workbook called Worksheet 2.
Method #4 – Copy Sheet to Another workbook
If you want to Copy the entire worksheet to new workbook you can apply this method.
- Right click on the sheet you want to move and select Move or Copy. Here I have selected the sheet called Data Sheet in the workbook called Worksheet 2.
- Once you select this option it will show you the new window.
- In this window, there is a drop down called To book: Click on this drop-down it will show you all the opened workbooks, select the workbook you want to move. I have selected the workbook called Worksheet 1. Here I am selecting the option Create a copy. Once you select the new workbook name it will show you that workbook’s worksheets. Select the option of (move to end). Click on OK.
- It will create a copy of this worksheet to another workbook.
Things to Remember about Copy Excel Sheet
- Based on the requirement we can choose whether to move or copy the excel sheet.
- The shortcut key to open the Move or Copy sheet is ALT + E + M.
- We need to select the required workbook name To book: drop-down list.
- If you want to move the sheet to the extreme end we need to choose the option (move to end).
Recommended Articles
This has been a guide to Copy Excel Sheet. Here we discuss how to copy excel sheet by using different methods along with practical examples and downloadable excel template. You can also go through our other suggested articles –