How to Move or Copy Worksheets in Microsoft Excel?

In the previous article we saw “How to insert or delete sheet?“, now we will see how to move or copy worksheets in the same workbook or in a different workbook. So let’s start…

Table of Contents hide

1 Move worksheet in the same workbook

1.1 Move or Copy Via Shortcut Key

1.2 Move Between Worksheets

2 Move Worksheet to Different workbook

3 Share this:

Move worksheet in the same workbook

To move the excel sheet in the existing sheet, hold the sheet and drag it to where you want to move it.

Note: Select the Create a copy checkbox. If you want copy of the same worksheet.

You can move it via another way, Right click on the worksheet that you wan to move or copy then select the option “Move or Copy” and choose the worksheet before and after you want to copy it.

Move or Copy Via Shortcut Key

To Move or Copy worksheet via shortcut key, select the sheet that you want to move or copy and then press “ALT + E” and then “M” after that popup will come select the sheet where you want to move it.

Note: Select the Create a copy checkbox. If you want copy of the same worksheet.

Move Between Worksheets

To move between sheets, you need to hold the “CTRL” and Press Page up (PgUp) and paged Down (Pg Dn) button.

Move Worksheet to Different workbook

Note: When you move a sheet to a different workbook, check any formulas that may cause errors or you will get the wrong result.

To move the worksheet to a different workbook right-click on the sheet (Sheetname) that you want to move or copy, then choose the option “Move or Copy”. After that select the sheet and choose the new workbook or select the workbook that you want to move.

If you want to move only that sheet to another workbook and don’t want a copy in the existing sheet then don’t tick on “Create a copy”.