Excel Protect Sheet Not Working? Causes and Fixes

If Excel sheet protection seems not to work, first check that the sheet is actually protected and that the cells you expect to block are marked as locked. In Microsoft 365 for Windows, go to Review > Protect Sheet; if the command says Unprotect Sheet, protection is already on, so check the cell’s lock status, the allowed actions, and whether you are editing the correct worksheet.

What sheet protection does—and does not do

Excel worksheet protection controls which actions people can take on a particular sheet. It can prevent changes to locked cells while still allowing edits in designated input cells, and it can optionally restrict actions such as formatting, sorting, or inserting rows. Protection is configured separately for each worksheet.

It is not the same as encrypting a workbook or controlling who can open a file. A protected sheet is not a reliable way to keep confidential information secret or to stop a determined person from accessing it. For access control, use file permissions or encrypt the workbook with a password to open it. Sheet protection is mainly useful for preventing accidental changes to formulas, layouts, and other parts of a working sheet.

There are also two different protection commands that are easy to confuse. Protect Sheet applies restrictions to the active worksheet. Protect Workbook can restrict changes to the workbook’s structure, such as adding, moving, deleting, hiding, or renaming sheets. Protecting the workbook structure does not, by itself, lock cells on a sheet.

Check whether protection is actually turned on

Select the worksheet where the problem occurs, then open the Review tab. If the button reads Unprotect Sheet, Excel considers that worksheet protected. If it reads Protect Sheet, protection is off for that sheet. A workbook can contain several sheets with different protection states, so check the tab you are trying to edit rather than assuming the whole workbook has one setting.

If you can type into a cell you thought was protected, try selecting that exact cell and typing a small, harmless test value. Excel normally displays a warning when you attempt to change a locked cell on a protected sheet. If it accepts the change, undo the test immediately and investigate whether that cell is unlocked, whether the selected sheet is protected, or whether the edit is occurring in a different copy of the file.

Also check whether the workbook is open in view-only or read-only mode. That can prevent edits for a different reason, but it does not mean sheet protection is working. Look for a read-only notice, an editing-permission message, or a prompt to save a copy. File access and worksheet protection are separate controls.

Locked cells are not protected until you protect the sheet

One of the most common causes is misunderstanding the Locked setting. In a new Excel worksheet, cells are generally marked as locked by default, but that setting has no effect until you turn on sheet protection. Conversely, if a cell was unlocked before protection was enabled, users can continue editing it while other locked cells are restricted.

To inspect a cell in Excel for Microsoft 365 on Windows, select it and press Ctrl+1 to open Format Cells. Choose the Protection tab and check whether Locked is selected. On Mac, use Command+1 to open Format Cells. If the cell should be protected, select Locked, click OK, and then protect the sheet. If the sheet is already protected, you will need to unprotect it before changing the cell’s protection setting.

For a typical form, you might leave cells B2:B10 unlocked for data entry and keep formula cells in C2:C10 locked. Select the cells users should edit, open Format Cells, clear Locked, and then protect the sheet. This gives users a clear path to enter information without permitting changes to the formulas. Remember that formatting cells as locked is not enough on its own: the sheet must also be protected.

Review the options selected when you protected the sheet

When you choose Review > Protect Sheet, Excel presents options for what users may still do. The exact options you chose can explain why an action that seems like an edit is still allowed—or why an ordinary task is blocked. For example, allowing users to select locked cells does not let them change those cells; it only permits selecting them.

Depending on the sheet and Excel version, the protection dialog can allow actions such as selecting unlocked cells, formatting cells or columns, inserting rows, sorting, using AutoFilter, or working with PivotTables. If a user needs to filter a protected list, for example, the sheet may need to be protected with the relevant filtering permission enabled. Allowing one action does not automatically allow related actions.

To change the settings, unprotect the sheet, then protect it again and review the options. If the sheet uses a password, Excel asks for it when you unprotect. Be specific about the permissions you grant: allowing formatting or inserting rows may be convenient, but it can also make a carefully laid-out worksheet easier to alter.

Look for range, selection, and table complications

Some failures affect only a portion of a sheet. A user may be able to edit one input cell but not another because the cells have different Locked settings, or they may be unable to select a cell because the protection options restrict selection. A cell that cannot be selected is not necessarily protected more strongly; it may simply be inaccessible under the current selection settings.

Sorting and filtering can be especially confusing. A protected sheet may allow filtering while preventing other changes to the data. Sorting a range that contains locked cells can also be restricted, even when users are allowed to sort in the protection dialog. Test the exact operation on a copy of the sheet and check whether the list includes locked cells, formulas, or a table with its own expected behavior.

Check merged cells and objects as well if the complaint concerns more than cell contents. Sheet protection can apply to drawing objects and other elements, and the protection dialog includes separate options for some of them. A user who can edit cells but can still move a shape may be seeing a different protection setting, not a failure of cell locking.

Distinguish sheet protection from file and sharing permissions

A password prompt when opening a workbook is different from a password prompt when unprotecting a sheet. The first is related to opening or encrypting the file; the second controls removal of sheet restrictions. Likewise, a message that you lack permission to edit a file stored in OneDrive or SharePoint points to sharing or file permissions, not a cell’s Locked setting.

In a shared workbook, verify that you have editing access and that you opened the intended file, not a downloaded copy or an older version. Cloud synchronization can make it appear that a protection change did not take effect if another copy is open or the latest save has not synced. Check the file name and location, close duplicate copies, and confirm that changes have finished saving before testing again.

Excel for the web supports worksheet protection, but its interface and available controls may not match the Windows desktop version in every situation. If you cannot find a particular protection option, use Open in Desktop App and review the settings in Excel for Microsoft 365 on Windows. On Mac, use the Review tab for sheet-protection commands; dialog details can differ by version.

What to do if you do not know the password

If Excel asks for a password to unprotect a sheet and you do not have it, ask the workbook owner or the person who set up the file. They can provide the password, make the needed change, or supply an authorized unprotected copy. If the workbook belongs to an organization, contact its IT or document owner rather than trying to bypass its controls.

Excel does not provide a general password-recovery button for removing worksheet protection. Do not confuse a forgotten sheet password with a forgotten password used to encrypt a workbook: the latter can prevent opening the file at all. In either case, check for a legitimate backup or earlier version, and preserve the original before making changes. If you can open the file but cannot edit one sheet, a backup may help recover the content, but it does not reveal the password.

A practical troubleshooting sequence

Select the exact worksheet and check Review > Protect Sheet. Confirm whether the sheet is protected.
Test the exact cell or action that is failing, then undo any harmless test edit.
If the sheet is protected, ask whether the cell should be editable. Inspect its Locked setting in Format Cells after unprotecting the sheet if necessary.
Review the protection options for the action in question, such as filtering, formatting, or selecting cells.
Check for read-only access, cloud-sharing restrictions, duplicate workbook copies, or an unsynced save.
If a password is required, get it from the owner or restore an authorized backup. Do not treat protection as a substitute for access permissions.

This sequence helps separate a setup issue from an access issue. If only one cell behaves unexpectedly, inspect that cell’s lock state first. If every cell behaves unexpectedly, confirm the active sheet and protection status before changing individual cells.

Frequently Asked Questions

Why can I still edit cells after protecting an Excel sheet?
Those cells may be unlocked, or you may be editing a different worksheet or file. Excel’s Locked setting only restricts editing after protection is enabled, so check the exact cell and the sheet’s protection status.

Why can’t I edit a cell even though I selected it as unlocked?
Confirm that you cleared the Locked setting for the correct cell, then unprotect and reprotect the sheet if you changed settings while protection was off. Also check that the workbook is not read-only and that you have permission to edit it.

Does protecting a sheet stop someone from opening or copying the workbook?
No. Sheet protection limits certain changes within the worksheet; it does not encrypt the file or control who can open it. Use file encryption and appropriate sharing permissions when access to the workbook’s contents must be restricted.

Why does Excel ask for a password when I click Unprotect Sheet?
The sheet was protected with a password. You need the password from the person who set up the protection. If you do not have it, request an authorized change or an earlier backup rather than attempting to bypass the restriction.

Why can users filter a protected sheet but not sort it?
Filtering and sorting are separate actions, and protection settings can allow one without allowing the other. Sorting may also be blocked by locked cells in the range. Review the protection options and test the exact data range.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.