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…

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.

Drag and drop move sheet

OR

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.

Right click and move 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.

Short cut to move copy 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 between the sheet

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 onCreate a copy”.

Move worksheet to new workbook

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

Copy worksheet to new workbook

For Latest Updates & Learning Join Our YouTube Channel: Join Now


EduTaxTuber Team

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply