-
Control-click on a worksheet tab and select Move or Copy.
-
Select or clear the Create a copy checkbox to copy or move a sheet.
-
Under To book, choose the current workbook or another workbook.
-
Under Before sheet, choose where you want to place the copy and select OK.
-
Right-click the worksheet tab and select Duplicate.
-
Click and drag the new tab to where you want it positioned.
-
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.