If Excel’s Protect Sheet command is greyed out, first exit cell-edit mode, select a regular worksheet tab, and check whether the workbook is using the legacy Shared Workbook feature; then try Review > Protect Sheet. A read-only file may stop you saving changes, but read-only status alone is not usually the reason this command is disabled.
What Protect Sheet does—and what it does not do
Protect Sheet controls whether people can change cells and perform certain actions on a worksheet. In Microsoft 365 for Windows, select the worksheet, open the Review tab, and choose Protect Sheet. In the dialog, you can optionally enter a password and choose which actions users are allowed to perform, such as selecting cells or sorting data. Select OK to apply the settings.
Protection does not automatically make a worksheet read-only in every respect. By default, cells are marked as locked, but that setting only takes effect after you protect the sheet. You can unlock input cells before applying protection, so users can enter data in designated areas while formulas and headings remain protected. To unlock a range, select its cells, press Ctrl+1, open the Protection tab, clear Locked, and then protect the sheet. On Mac, use Command+1 to open Format Cells.
Worksheet protection is also different from protecting the workbook’s structure. Protect Workbook can limit actions such as adding, deleting, moving, hiding, or renaming sheets. It does not replace Protect Sheet, which governs changes within a particular worksheet. Neither feature is a substitute for encrypting a file that contains confidential information. Treat sheet protection as a way to prevent accidental edits and control ordinary worksheet actions, not as strong security.
Start with these quick checks
Before changing workbook settings, check whether Excel is temporarily in a state that disables ribbon commands. These steps resolve many cases without changing the file’s sharing or protection settings:
- Finish editing the current cell. If a cell is being edited, press Enter to commit the change or Esc to cancel it. Then check the Review tab again. Commands can be unavailable while Excel is waiting for you to finish an edit or close a dialog.
- Select a worksheet tab. Click the tab for the sheet you want to protect. A chart sheet is not a regular cell-based worksheet and does not use the same Protect Sheet command.
- Check for grouped sheets. If the title bar or sheet tabs indicate that multiple sheets are selected, click a single worksheet tab to work with one sheet. If necessary, right-click a selected tab and choose Ungroup Sheets.
- Look at the command’s label. If it says Unprotect Sheet instead of Protect Sheet, the active worksheet is already protected. Selecting Unprotect Sheet may prompt for the password.
- Close any open dialog or prompt. Finish or cancel the prompt, return to the worksheet, and try the command again.
These checks are useful because a disabled button does not always mean the workbook has a permanent restriction. The command can be unavailable because the current selection or editing state is wrong, even when you have permission to protect the worksheet.
Check whether the workbook uses legacy sharing
A legacy Shared Workbook is a feature for older multi-user editing workflows. It is not the same as the current practice of storing a workbook on OneDrive or SharePoint and collaborating through co-authoring. In a legacy shared workbook, Excel restricts some changes, including assigning or changing worksheet and workbook passwords. That can prevent you from applying protection even if the sheet itself is not protected.
If you suspect legacy sharing, look for signs that the workbook is marked as shared or for the legacy sharing controls in Excel. The exact location of those controls can vary, and the legacy command may not be shown on a customized ribbon. Do not remove sharing casually: other people may rely on the shared file, and switching out of the legacy feature can affect how changes are combined. If you are authorized to change the setup, make a separate copy first, coordinate with collaborators, and then remove legacy sharing using the available Share Workbook (Legacy) controls. Reopen the copy and try Review > Protect Sheet.
Modern co-authoring through OneDrive or SharePoint is a different system. Do not assume that a cloud location means the workbook is in legacy Shared Workbook mode. If the command is disabled in a modern shared file, check the selected tab, your editing permissions, and whether Excel has opened the file in a mode that permits editing.
Distinguish worksheet protection from workbook protection
It is common to see a protected workbook and assume that this is why Protect Sheet is unavailable. The two protections have separate purposes. A workbook structure password can stop someone from renaming or deleting a sheet, for example, but it does not ordinarily prevent you from protecting cells on a worksheet. Conversely, protecting a worksheet does not stop someone from adding or renaming other sheets if the workbook structure is unprotected.
Check the Review tab to see which protection commands are available. If Excel offers Unprotect Sheet, protection is already applied to the selected worksheet. If it offers Unprotect Workbook, the workbook structure is protected. A password prompt is not the same as a greyed-out command: it means Excel is asking for authorization to remove an existing restriction. If you do not know the password, ask the workbook owner or administrator. Do not assume that a file’s owner can recover a forgotten worksheet password through the normal interface.
Read-only files, Protected View, and permissions
Read-only status is worth checking, but it is often misunderstood. A read-only workbook can generally be edited in the open session, depending on how it was opened, but Excel may prevent you from saving those changes back to the original file. If you can apply sheet protection but cannot save it, use Save As to create a permitted copy or ask the file owner for edit access. Whether Save As is available depends on the file location and your permissions.
Protected View is different. Excel may open a file from an untrusted location in a restricted mode, with an Enable Editing button in a warning bar. If you trust the file and its source, select Enable Editing, then check the Review tab. Do not enable editing simply to bypass a warning on a file you do not trust; first verify where it came from. Similarly, a permissions label or organizational policy may limit editing in a cloud document. In that case, request the appropriate access rather than trying to change the workbook’s protection settings.
Excel for the web and Excel for Mac
The ribbon is not identical in every version of Excel. In Excel for the web, open the Review tab and look for Manage Protection or the protection controls available in that interface. The web app can handle common worksheet protection tasks, but some options and workbook features differ from desktop Excel. If a required control is missing or unavailable, use Open in Desktop App, provided you have access to the desktop version and permission to edit the file.
In Excel for Mac, select the worksheet and look on the Review tab for Protect Sheet. The dialog and wording can differ slightly from Windows, but the distinction between worksheet protection and workbook-structure protection is the same. If a button is disabled, check that you are on a worksheet rather than a chart sheet, that you have finished editing a cell, and that the workbook is not in a restricted sharing or permissions state. For either platform, compare the exact command and status shown in your version rather than following instructions written for a different Excel interface.
If Protect Sheet is still unavailable
If the basic checks do not explain the problem, narrow it down without risking the original workbook. Save a copy under a new name if you can, close and reopen that copy in the Excel desktop app, and test the command on a normal worksheet. If the copy works but the original does not, a workbook-specific setting, sharing mode, or permission is likely involved. If it remains disabled in a new blank workbook too, the issue may relate to the app state, installation, or a managed device policy rather than that one file.
When asking for help, note the Excel platform, the exact label on the Review tab, whether the file is stored locally or in a shared location, and whether you can edit and save other changes. Those details help distinguish a greyed-out command from a password prompt or a save failure. If the workbook belongs to someone else or is managed by an organization, ask its owner or administrator before removing sharing, changing access, or creating a replacement copy.
Also remember that enabling protection is not the same as deciding which cells should remain editable. For a data-entry sheet, test the finished setup with a non-owner account or a separate copy: try editing an input cell, changing a formula cell, sorting if users need to sort, and saving. That simple check catches common configuration mistakes, such as leaving all cells locked or forgetting to allow a required action.
Frequently Asked Questions
Why is Protect Sheet greyed out in Excel?
Common causes include being in cell-edit mode, selecting a chart sheet instead of a worksheet, using a legacy Shared Workbook, or lacking permission to edit the file. Exit the edit, select a worksheet tab, and check the Review tab again.
Does Protect Workbook stop me from protecting a sheet?
Usually, no. Protect Workbook controls the workbook structure, while Protect Sheet controls worksheet actions and cells. They are separate settings, so check whether the selected sheet is already protected or the file is using a restricted sharing mode.
Can I protect a worksheet if the workbook is read-only?
You may be able to apply protection in the open session, but you might not be able to save it back to the read-only original. If Excel permits it, save a separate copy or ask the owner for edit permission.
What if the button says Unprotect Sheet?
The selected worksheet is already protected. Choose Unprotect Sheet if you have authorization to remove that protection; Excel may ask for a password. If you do not know it, contact the workbook owner.
Does sheet protection keep data confidential?
No. Worksheet protection is mainly intended to restrict changes and prevent accidental edits. Use appropriate file encryption and access permissions when information needs confidentiality.
Related
- Uni Budget Spreadsheet: Build a Student Budget in Excel
- Excel Power Query Editor: What It Does and How to Use It
- Excel Power Query: How to Extract and Refresh Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Use Styles from Another Word Document in WordTo use styles from another Word document, copy them with Word’s Organizer, then apply the imported styles to…
- Weekly Budget Spreadsheet: Build a Clear Excel PlanA weekly budget spreadsheet is a simple way to compare the money you expect to receive with the…
- Monthly Budget vs Actual Excel Template: How to Build OneA monthly budget vs actual Excel template compares what you planned to spend with what you actually spent,…
- Enter Serial Numbers in Excel: Manual and Automatic MethodsTo create a numbered list in Excel, enter 1 and 2 in the first two cells, select both,…
- Excel Named Range Won’t Delete? Causes and Fixes to TryNo—Excel can delete most named ranges, which it calls defined names. In Excel for Microsoft 365 on Windows,…
- Hide Cells in Excel: Shortcut Keys for Rows and ColumnsIn Excel for Microsoft 365 on Windows, select a cell in the row and press Ctrl+9 to hide…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.