Restore the Move or Copy Sheet Command in Excel | WPS Office
Question details
The user needs to restore the Move or Copy Sheet command when it is missing or disabled in the worksheet tab right-click menu.
- Product
- WPS Office Spreadsheets and Microsoft Excel workbooks
- Device & OS
- not provided
- Scenario
- The user is managing worksheets in an Excel workbook and wants to move or copy a sheet, but the right-click command is unavailable.
- Observed behavior
- The Move or Copy Sheet option is missing or grayed out when right-clicking a worksheet tab, often because the workbook structure is protected.
Open the workbook in WPS Office Spreadsheets and note whether the Move or Copy Sheet command is missing in every workbook or only the current file. Check whether you have permission to unprotect the workbook structure before making changes.
Check and remove workbook structure protection
Use this solution first when the Move or Copy Sheet command is disabled in a protected workbook.
Workbook structure protection disables sheet actions such as insert, delete, rename, move, and copy. Removing that protection restores the right-click command.
Open the affected workbook in WPS Office Spreadsheets. If the command is disabled in all workbooks, test with a new blank workbook to see whether the issue is file-specific.
Click the Review tab on the ribbon, then select Protect Workbook. If the workbook is already protected, the option appears as Unprotect Workbook.
Click Unprotect Workbook, enter the password if prompted, and click OK. If you do not have permission or do not know the password, contact the workbook owner.
Right-click the worksheet tab, choose Move or Copy Sheet, set the destination workbook and sheet position, check Create a copy if needed, and click OK.
Move or copy a sheet by dragging as a temporary workaround
Use this method when you cannot unprotect the workbook immediately but still need to rearrange or duplicate a sheet.
Restore Move or Copy Sheet in WPS Office Spreadsheets
Open the workbook in WPS Office Spreadsheets, remove workbook structure protection if present, and use the right-click Move or Copy Sheet command to reorganize your sheets. WPS Spreadsheets keeps Excel workbook formatting intact and works with common Microsoft Excel file formats.
- 1. Download and open WPS Office: Download WPS Office from the official site, install it, and open the affected workbook in WPS Spreadsheets.
- 2. Unprotect the workbook if needed: Go to Review, click Protect Workbook, select Unprotect Workbook, enter the password if prompted, and click OK.
- 3. Use Move or Copy Sheet: Right-click the sheet tab, choose Move or Copy Sheet, select the destination workbook and position, check Create a copy if needed, and click OK.
- 4. Save in Excel format: Press Ctrl+S or click Menu and use Save As to save the file as Excel Workbook .xlsx so it remains compatible with Microsoft Excel.
Frequently Asked Questions
Why is Move or Copy Sheet missing from the right-click menu in Excel?
The most common cause is workbook structure protection. In WPS Spreadsheets, open the workbook, go to Review, click Protect Workbook, and choose Unprotect Workbook to remove the restriction.
How do I unprotect a workbook in WPS Spreadsheets?
Open the workbook, click the Review tab, select Protect Workbook, then click Unprotect Workbook. Enter the password if prompted and click OK.
Can I move or copy a sheet to another workbook in WPS Office?
Yes. Right-click the sheet tab, choose Move or Copy Sheet, select the target workbook from the destination list, choose the sheet position, and check Create a copy if you want a duplicate.
Will unprotecting the workbook permanently remove protection?
It removes protection from the current workbook. Save the workbook after unprotecting it to keep the change. If you do not know the password, contact the person who protected the workbook.
Does WPS Office support the Excel Move or Copy Sheet command?
Yes. WPS Spreadsheets includes the same Move or Copy Sheet command and supports Excel workbook formats such as .xlsx, .xls, and .csv.
