Easy Tech TutsHow to Unprotect a Sheet in Microsoft Excel Easily 2026
By Impran M N
Grayed-out formatting options and blocked cell errors usually mean a worksheet has protection turned on. This guide covers finding the Unprotect Sheet command in the Review tab, entering a password if the sheet is encrypted, and confirming your data is fully editable afterward.
01Spot the protection indicators
Double-click an active cell and note any error prompt that confirms the sheet is protected.
02Open the Review tab
Move to the ribbon menu and click into the Review tab.
03Click Unprotect Sheet
Find the Protect tool section and click Unprotect Sheet.
04Enter the password if required
If the sheet is encrypted, type the security key into the pop-up field and click OK.
05Try the Home tab alternative
You can also find this option under the Home tab's Cells section by opening the Format dropdown and selecting Unprotect Sheet.
06Check workbook-level locks
If structural changes like adding sheets are also blocked, click Unprotect Workbook as well.
Frequently asked questions
What if I don't know the password for a protected sheet?
You'll need to enter the correct security key to unprotect it, so reach out to whoever originally set the password if you don't have it.
Can I let others edit certain cells without fully unprotecting the sheet?
Yes, use the Protect Sheet dialog to check specific permission boxes that allow limited formatting or editing while protection stays active.
Is unprotecting a sheet different from unprotecting a workbook?
Yes, sheet protection controls individual cell locks, while workbook protection controls structural changes like adding or removing sheets.
How do I confirm the sheet is fully unlocked?
Double-click into your columns and rows to verify that typing, filtering, and formatting changes all work without errors.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
