M365 Excel - Move or Copy worksheets or worksheet data

Move a worksheet within a workbook

• Select the worksheet tab, and drag it to where you want it.

  Caution: When you move a sheet to another workbook, check any formulas or charts that refer to data on the sheet because moving the sheet might cause errors or produce unintended results in your data. Similarly, if you move a sheet that is referred to by 3-D references, the calculation might include or leave out data on the sheet.

Copy a worksheet in the same workbook

• Press CTRL and drag the worksheet tab to the tab location you want.

OR

1. Right click on the worksheet tab and select Move or Copy.
2. Select the Create a copy checkbox.
3. Under Before sheet, select where you want to place the copy.
4. Select OK.