Copy or move a worksheet

1. Control-click on a worksheet tab and select Move or Copy.

2. Select or clear the Create a copy checkbox to copy or move a sheet.

3. Under To book, choose the current workbook or another workbook.

4. Under Before sheet, choose where you want to place the copy and select OK.

1. Right-click the worksheet tab and select Duplicate.

2. Click and drag the new tab to where you want it positioned.

3. Right-click and select Rename to change the tab's name.

You can only copy sheets in the same workbook. To copy to another workbook, use Excel desktop. 

• To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.

  

Don't have the Excel desktop app? Try or buy Microsoft 365.