Excel Protect Sheet Greyed Out? Causes and Fixes

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, Protect Sheet is usually greyed out because Excel cannot currently edit the worksheet or workbook, or because the file is in a restricted state such as Protected View, a legacy shared-workbook arrangement, or an unsupported file format. Check that you can edit the file, select one worksheet, and save it as an Excel workbook; then look on the Review tab for Protect Sheet.

What the command does—and where to find it

Protect Sheet controls which actions people can take on one worksheet. In the Windows desktop app, select the worksheet and choose Review > Protect Sheet. The dialog lets you choose permitted actions, such as selecting locked cells, formatting cells, or inserting rows. You can optionally set a password. The exact appearance of the Review tab can vary with the ribbon layout, but the command belongs to the sheet-protection controls.

Protection is not the same as making a file read-only or encrypting it. It is commonly used to prevent accidental edits to formulas or layout while leaving designated input cells available. By default, cells are marked as locked, but that setting has no effect until sheet protection is turned on. A typical setup is to unlock the cells intended for data entry, then protect the sheet and allow users to select or edit those unlocked cells.

Check whether Excel is allowing edits

If the workbook has opened in Protected View, Excel may block editing commands. Look for a security banner near the top of the window. If you trust the file and its source, use Enable Editing; do not enable editing for an unexpected attachment or a file from an untrusted source just to make the command available. In a work or school environment, policy settings can prevent you from leaving Protected View.

Also check whether the file is open with view-only access or whether your account has permission to edit it. A read-only label does not always disable every command: Excel may let you make changes in a temporary copy or require you to save a separate copy. The important distinction is whether you have permission to change the workbook itself. If you cannot edit, ask the owner for edit access or use File > Save As to create a copy in a supported workbook format, if your organization permits that.

  • Look for a Protected View or permissions banner and read what it says.
  • Check the file name or title bar for a read-only indication.
  • If the workbook is stored in OneDrive or SharePoint, confirm that you are signed in to the account with editing rights.
  • Try a new blank workbook. If Protect Sheet works there, the restriction is probably specific to the original file or its access settings.

Look for sharing and collaboration restrictions

Some older Excel workbooks use the legacy Shared Workbook feature, which is different from modern coauthoring through OneDrive or SharePoint. Legacy shared workbooks have restrictions on workbook changes, and protection settings can be among the operations that cannot be changed while that sharing mode is active. If you suspect this, ask the workbook owner or administrator to check the workbook’s legacy sharing settings. Do not turn off sharing casually: doing so can affect other people’s access and changes.

Modern coauthoring by itself is not a universal reason for Protect Sheet to be unavailable. A workbook stored online can still support protection, subject to your permissions and the features available in the app. If only one person sees the command disabled, compare account permissions and whether that person opened the file in editing mode. If the issue affects everyone, investigate the workbook’s format, protection, or legacy sharing state instead.

Check the file format and Excel version

Sheet protection is a workbook feature, so a text-only format such as CSV cannot preserve it. If the file is a CSV or another limited format, use File > Save As and choose an Excel workbook format such as Excel Workbook (*.xlsx) or, when the workbook contains macros, Excel Macro-Enabled Workbook (*.xlsm). Work from a copy when changing formats, because CSV does not retain many Excel features, including multiple worksheets, formatting, and protection settings.

If you are using Excel for the web, confirm that you have editing permission and are not in view-only mode. The web interface may present sheet protection through a Review tab control such as Manage Protection, and the available options can differ from the Windows desktop dialog. If a feature or control is unavailable in the browser, open the file in the desktop app if you have access to it. On Excel for Mac, start on Review > Protect Sheet; ribbon placement and dialog details can differ, but the core purpose is the same.

Make sure the worksheet selection is not confusing the issue

Check that a worksheet tab is selected and that the workbook is not in a dialog or editing state that prevents commands from being used. If several worksheet tabs are selected, Excel has grouped the sheets. Right-click a selected sheet tab and choose Ungroup Sheets, or click a single unselected sheet tab, then check the Review tab again. Grouping can make it unclear which sheet a command applies to; selecting one sheet is a useful diagnostic even when grouping is not the cause.

Look at the command’s label, too. If the sheet is already protected, Excel normally shows Unprotect Sheet rather than leaving Protect Sheet greyed out. Choosing that command may ask for a password. Workbook-structure protection is separate: it restricts actions such as adding, deleting, moving, hiding, or renaming sheets. It does not, by itself, mean that the active sheet is protected. If you can select cells but cannot change the workbook’s sheet tabs, investigate workbook protection rather than assuming the worksheet command is broken.

A practical troubleshooting sequence

Work through these checks in order. After each change, return to the Review tab and see whether the command is available. This helps identify the cause rather than changing several workbook settings at once.

  1. Select one worksheet. Click its tab and ungroup sheets if multiple tabs are selected.
  2. Check the editing state. Read any Protected View or permissions banner. Enable editing only if you trust the file and are authorized to edit it.
  3. Check the format. If the file is CSV or another limited format, save a separate copy as XLSX or XLSM as appropriate.
  4. Check access and sharing. Confirm that you have edit permission, and ask the owner whether the file uses legacy Shared Workbook mode.
  5. Reopen or test a copy. Close and reopen the workbook, or use Save As to make a permitted working copy. If the command works in a new workbook but not this one, focus on the original workbook’s restrictions.

If none of these checks helps, note the exact file extension, whether the workbook is stored locally or online, which Excel app you are using, and what the Review tab displays. Share those details with the workbook owner or IT support. Avoid removing protection or changing sharing settings without permission, especially in a shared business file.

Protection is not encryption or a strong security boundary

Worksheet protection is useful for guiding normal editing and preventing accidental changes, but Microsoft does not present it as a way to secure sensitive data. It should not be treated as file encryption, access control, or a substitute for limiting who can open a workbook. Use file-level permissions and appropriate encryption controls when confidentiality matters.

Protection also does not automatically make only some cells editable. To create an input area, select the cells people should change, open Format Cells, go to the Protection tab, and clear Locked. Then turn on sheet protection and choose the actions users should be allowed to perform. For example, in a budget template you might leave the quantity and unit-price cells unlocked while protecting cells containing formulas. Test the setup with a copy so the allowed actions match what users need.

Frequently Asked Questions

Why is Protect Sheet greyed out in Excel but other Review commands work?
That usually points to a restriction specific to the workbook or active sheet rather than a general ribbon problem. Check editing permission, file format, legacy sharing, and whether multiple sheets are grouped. Test the command in a new workbook to see whether the cause follows the file.

Does a protected worksheet make Protect Sheet grey?
Normally, Excel changes the command to Unprotect Sheet when the active worksheet is already protected. If that command is available, removing protection may require the password. If you do not know it, contact the workbook owner; do not assume workbook-structure protection is the same setting.

Can I protect a sheet in Excel for the web?
Excel for the web supports worksheet protection in supported workbooks, but its controls and options can differ from desktop Excel. Check the Review tab for the available protection or management control and confirm that the workbook is open for editing. If the control is unavailable, try the desktop app or ask the owner to check your permissions.

Will saving as XLSX remove the greyed-out command?
It can help when the current file is CSV or another format that cannot retain worksheet protection. Save a separate copy as XLSX or XLSM, then check the Review tab. Changing formats will not fix missing edit permission, Protected View, or every sharing restriction.

Is Protect Sheet the same as Protect Workbook?
No. Protect Sheet limits actions on an individual worksheet, while workbook-structure protection limits changes to the workbook’s sheet organization, such as moving or deleting tabs. Neither is the same as encrypting a file so that opening it requires a password.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.