Copy Excel Sheet

Copy Excel Sheet (Table of Contents)

• Copy Sheet in Excel
• How to Copy an Excel Sheet?

Copy Sheet in Excel

There are 2 ways to copy any worksheet. By the first way, click right on any Sheet name tab name 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 a tick and press Ok to proceed with creating a copy of that sheet. In a second way, select the sheet we want to copy, then process Ctrl and drag that sheet on the Plus sign 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. It will move the sheet to a new workbook but will disappear from the existing worksheet if you move.
• 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 sheets 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. For example, look at the below image. I have a total of 3 worksheets.

Right now, Sheet 1 is at the beginning of all the worksheets. So 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.

• 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 a 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 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 a 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 a 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 a 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.

• There is a drop-down called To book in this window: Click on this drop-down; it will show you all the opened workbooks and 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 sheets using different methods and practical examples, and a downloadable excel template. You can also go through our other suggested articles –

1. Excel Data Formatting
2. Scrollbar in Excel
3. Excel Absolute Reference
4. HYPERLINK in Excel