Permission & Access Issues

How to Enable Move or Copy Sheet in a Protected Excel Workbook

Huma Ashraf Ch Oct 9, 2026 871 views

Question details

The user is unable to use the Move or Copy Sheet command in an Excel workbook because the option is greyed out or disabled.

How to Enable Move or Copy Sheet in a Protected Excel Workbook

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to reorganize or duplicate worksheets within a workbook.
Observed behavior: The 'Move or Copy' option is disabled in the sheet tab context menu due to hidden or forgotten workbook protection.

Before you start

Ensure you have the authorization to modify the workbook structure and contact the file owner if a password is required to lift the protection.

Solution 1Recommended

Check and Disable Workbook Protection

Identify if the workbook structure is protected and remove the restriction to re-enable sheet movement.

Often, workbook protection is enabled to prevent structural changes, which disables the ability to move, copy, insert, or delete sheets. This protection can be applied with or without a password. Disabling it will restore normal functionality.

Navigate to the Review Tab

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

Check Workbook Protection Status

Look for the 'Protect Workbook' button. If it appears highlighted or pressed, the workbook structure is currently protected.

Unprotect the Workbook

Click on 'Protect Workbook'. If no password was set, clicking this will instantly remove the protection. If a password is required, a prompt will appear; enter the password provided by the file owner and click 'OK'.

Verify the Fix

Right-click on any sheet tab at the bottom of the window to verify that the 'Move or Copy' option is no longer greyed out.

Password Prompt Behavior: If clicking 'Protect Workbook' immediately prompts you to create a new password, it means the workbook was not structurally protected. In this case, the greyed-out option might be caused by grouped sheets or Legacy Shared Workbook settings.

Manage Workbook Protection with WPS

Easily Manage Sheet Protection with WPS Spreadsheet

WPS Office offers full compatibility with Microsoft Excel files. You can effortlessly manage workbook structures, remove protection, and move or copy sheets using the highly intuitive WPS Spreadsheet.

1. Open the file in WPS: Launch WPS Office and open your protected Excel workbook.
2. Navigate to the Review tab: Click on the 'Review' tab located in the top menu ribbon.
3. Unprotect the workbook: Click 'Unprotect Workbook'. Enter the password if prompted, and the Move or Copy feature will be instantly restored.

Fully compatible with Microsoft Excel formats (.xlsx, .xls) and protection settings.Intuitive and user-friendly interface for managing workbook structures.Lightweight, fast, and completely free to use for daily spreadsheet tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Move or Copy option greyed out if there is no password?

Workbook protection can be applied without setting a password to prevent accidental structural changes. Clicking 'Protect Workbook' on the Review tab will instantly disable the password-less protection and restore the Move or Copy feature.

Can I move or copy a sheet if the workbook is shared?

In older versions of Excel, the Legacy Shared Workbook feature prevents users from modifying the workbook structure, which disables moving or copying sheets. You must turn off the legacy sharing feature under the Review tab to restore this function.

How do I know if the workbook is protected before trying to move a sheet?

Go to the Review tab. If the 'Protect Workbook' button appears highlighted or depressed, the workbook is structurally protected. Additionally, right-clicking a sheet tab will show structural options like Insert, Delete, Rename, and Move or Copy as greyed out.

Document & File Issues