Document Editing Problems

How to Fix Cannot Move or Copy an Excel Worksheet

Phi Hung Vo Oct 22, 2026 868 views

Question details

The user is unable to move or duplicate a worksheet within an Excel workbook because the operation is blocked by structural protection or other file restrictions.

How to Fix Cannot Move or Copy an Excel Worksheet

Product: Excel
Device & OS: not provided
Scenario: Attempting to reorganize a workbook by moving or duplicating a specific worksheet tab.
Observed behavior: The Move or Copy options are grayed out, preventing the user from altering the sequence or duplicating the worksheet.

Before you start

Ensure you have editing permissions for the document. If the file was secured by another user, you may need to ask them for the workbook protection password.

Solution 1Recommended

Disable Workbook Structure Protection

Removing workbook protection is the most common and direct fix when structural changes like moving or copying sheets are blocked.

Excel allows users to lock the structure of a workbook to prevent unintended changes. When this is enabled, adding, deleting, hiding, moving, or copying sheets is strictly prohibited. You must disable this feature in the Review tab.

Navigate to the Review tab

Open your affected workbook in Excel and click on the 'Review' tab located on the top ribbon.

Click on Protect Workbook

Locate and click the 'Protect Workbook' button. If the workbook is currently protected, the button will be highlighted, and clicking it will prompt you to unprotect it.

Enter the password

If a password prompt appears, type the password provided by the document owner and click 'OK'.

Attempt to move or copy

Right-click the worksheet tab at the bottom of the screen. The 'Move or Copy' option should now be fully clickable and functional.

Legacy Shared Workbooks: If you are using an older version of Excel, having the 'Legacy Shared Workbook' or 'Track Changes' feature enabled can also restrict worksheet movement. Try turning these off from the Review tab if unprotecting the workbook doesn't resolve the issue.

Manage Spreadsheets Easily

Move, Copy, and Protect Worksheets seamlessly with WPS Office

WPS Office provides a highly compatible and user-friendly spreadsheet editor that lets you easily manage worksheet structures, apply or remove protection, and handle complex data tasks without restrictions.

1. Open your workbook: Launch WPS Spreadsheets and open the Excel file you want to edit.
2. Remove structural protection: Navigate to the 'Review' tab on the ribbon and click 'Unprotect Workbook' if the document structure is currently locked.
3. Select the worksheet: Right-click the specific worksheet tab at the bottom of your workspace and select 'Move or Copy'.
4. Finalize the action: Choose the destination location in the dialog box, optionally check 'Create a copy', and click OK to reorganize your document.

Fully compatible with Microsoft Excel (.xlsx, .xls) files and features.Intuitive Review tab to quickly unprotect or protect workbook structures.Lightweight architecture that opens large datasets instantly.Free and easy to use across Windows, Mac, Linux, and mobile devices.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Move or Copy option grayed out in my spreadsheet?

This usually happens when the workbook's structure is protected, which prevents users from adding, deleting, moving, or hiding sheets. It can also occur if the workbook is in a legacy shared state or has change tracking actively enabled.

Can I unprotect a workbook's structure without the password?

Standard features require the original password to unprotect a workbook. If you've forgotten it or do not have it, you will need to request it from the original author or revert to an older, unprotected backup copy.

How do I move a worksheet to a completely different workbook?

First, ensure both the source and destination workbooks are open in the same application instance. Right-click the worksheet tab you want to move, select 'Move or Copy', and in the 'To book' dropdown menu, select the name of your destination workbook.

Document & File Issues