Excel for the Web Duplicate Sheet Option Is Missing
Question details
The user wants to understand why the Duplicate worksheet command is unavailable in Excel for the web for some accounts.

- Product
- Microsoft Excel for the web
- Device & OS
- not provided
- Scenario
- The user needs to duplicate a worksheet in a browser-based Excel workbook.
- Observed behavior
- The usual Duplicate Sheet command is replaced by Copy and Paste or does not appear in the sheet tab menu.
Make sure you have editing permission for the workbook and that the worksheet is not protected. Open the workbook in a current browser session before checking the sheet tab context menu.
Refresh the Excel for the Web Session and Check Permissions
Use this when the Duplicate command previously appeared or is missing only for certain Microsoft 365 accounts.
Excel for the web commands can vary because of account permissions, tenant settings, browser sessions, and staged Microsoft 365 feature updates.
In Excel for the web, press Ctrl+R or use the browser Refresh button, then right-click the worksheet tab at the bottom of the workbook and check whether Duplicate is available.
Select your profile icon in the upper-right corner of Microsoft 365, choose Sign out, then sign in again with the account that has edit access to the workbook.
Open the workbook in Microsoft Edge, Google Chrome, or another updated browser, then right-click the worksheet tab to check the available commands.
Select the workbook name or sharing controls near the upper-right corner and confirm that your permission is Can edit. If the workbook or sheet is protected, ask the owner to remove the restriction.
If the command is still unavailable for only some users, ask the organization administrator to review Microsoft 365 service status and tenant-level feature availability.

Copy the Worksheet Contents as a Temporary Workaround
Use this when you need a copy immediately and the web version does not provide the Duplicate command.
Duplicate the Worksheet in Excel Desktop
Use this when you need a full worksheet copy and have access to the desktop version of Excel.
Duplicate Worksheets Easily with WPS Spreadsheets
If Excel for the web commands are unavailable for your account, WPS Office provides a free, lightweight spreadsheet alternative with a familiar worksheet interface. Open your Excel workbook in WPS Spreadsheets, duplicate a sheet from its tab menu, and continue working with compatible Excel files.
- 1. Open the Excel workbook in WPS Spreadsheets: Launch WPS Office, select Open, and choose the .xlsx or .xls workbook that contains the worksheet to copy.
- 2. Select the worksheet tab: At the bottom of the workbook, right-click the tab for the worksheet you want to duplicate.
- 3. Create a copy of the worksheet: Choose Move or Copy or the available sheet-copy command, select Create a copy, and confirm the destination position.
- 4. Save in Excel format: Select Menu > Save As and choose Excel Workbook (*.xlsx) to keep the workbook compatible with Microsoft Excel.

Frequently Asked Questions
Why does Excel for the web show Copy and Paste instead of Duplicate?
The available sheet commands can differ by Microsoft 365 account, organization tenant configuration, browser session, and staged feature rollout. Refreshing the session or signing in again may restore the command.
Can I duplicate a sheet in Excel for the web if the Duplicate command is unavailable?
Yes. Select the plus (+) button to add a worksheet, copy the cells from the original sheet with Ctrl+C, then select A1 on the new sheet and press Ctrl+V.
Does worksheet protection remove the Duplicate Sheet option?
It can. Check whether the workbook is opened with editing permission and whether sheet or workbook protection is enabled. The owner may need to remove protection or grant Can edit access.
How do I duplicate a worksheet in Excel desktop?
Right-click the worksheet tab, select Move or Copy, select the Create a copy check box, choose the placement, and select OK.
Can a Microsoft 365 administrator restore the missing Duplicate command?
An administrator can check Microsoft 365 service health, account licensing, and tenant feature availability. However, some Excel for the web interface changes are controlled by Microsoft service updates and cannot be manually rolled back.




