-
Right-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.
-
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.
Copying worksheets to another workbook isn't currently possible in Excel for the web. You can, however, copy worksheets to other workbooks in the Excel desktop app.
-
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.