How to Protect a Sheet in Excel
Excel protection has three layers: cell-level Locked property, worksheet-level Protect Sheet, and file-level encryption. Understanding which layer to use for what is the difference between protection that works and protection that doesn't.
⚡ Quick Answer
Go to Review → Protect Sheet. Optionally enter a password. Pick which actions users can still perform (default is fine for most cases). Click OK. Locked cells (all cells by default) can now only be edited after Unprotecting the sheet.
The three layers of Excel protection
| Layer | What it protects | Where to enable |
|---|---|---|
| Cell Locked property | Individual cells (nothing without sheet protection) | Format Cells → Protection tab |
| Protect Sheet | Cell edits, formatting, structure changes within one sheet | Review → Protect Sheet |
| Protect Workbook | Adding, deleting, renaming, moving sheets | Review → Protect Workbook |
| File encryption | Whole file — can't open without password | File → Info → Protect Workbook → Encrypt with Password |
Method 1: Protect a single sheet
Open the sheet you want to protect
Navigate to the correct worksheet.
Click Review → Protect Sheet
The Protect Sheet dialog opens.
Optionally set a password
Enter a password if you want to prevent unauthorized unprotection. Leave empty for casual protection.
Choose permitted actions
Tick which operations users can still perform: Select cells, Sort, Use AutoFilter, Format cells, etc. Default is "Select locked cells" + "Select unlocked cells" only.
Click OK and confirm password
If you set a password, re-enter it to confirm. The sheet is now protected.
Microsoft has no way to reset a forgotten Excel sheet password. Store passwords securely. Third-party tools exist but are unreliable and shouldn't be used on files that aren't yours.
Method 2: Protect only specific cells
The trick is the two-step process — mark cells as Locked (or unlocked), then enable Protect Sheet.
Unlock all cells first
Select all (Ctrl + A). Press Ctrl + 1. Protection tab. Uncheck Locked. OK.
Select the cells you want to protect
Highlight the specific cells (formulas, headers, calculated totals, etc.).
Enable Locked on those cells
Ctrl + 1 → Protection tab → check Locked → OK.
Protect the sheet
Review → Protect Sheet → set password if needed → OK. Only the cells you marked Locked in step 3 are protected.
See our Lock Cells guide for more detail on the two-step model.
Method 3: Protect Workbook structure
Prevents users from adding, deleting, renaming, moving, or hiding sheets. Content within sheets is not affected.
Click Review → Protect Workbook
Different button from Protect Sheet.
Tick "Structure"
Structure protection is the main option.
Set password (optional)
Same rules as Protect Sheet — password prevents unauthorized removal.
Click OK
Users can still edit cells (unless individual sheets are also protected) but can't restructure the workbook.
Method 4: File-level password (real security)
For genuinely sensitive data, encrypt the whole file. Users need the password just to open it.
Go to File → Info
Backstage view.
Click Protect Workbook → Encrypt with Password
Dropdown option.
Enter a strong password
File-level encryption is real security — modern AES-256. Choose a password worth using.
Confirm and save
Re-enter password. Save the file. Next time it's opened, Excel prompts for the password.
Casual (prevent accidental edits): Protect Sheet with no password.
Team file (prevent structural changes): Protect Workbook + Protect Sheet.
Confidential data: File-level encryption (Encrypt with Password). This is the only layer that's actually secure.
How to unprotect
Sheet protection
Review → Unprotect Sheet. Enter password if set.
Workbook protection
Review → Protect Workbook (same button; toggles). Enter password if set.
File encryption
File → Info → Protect Workbook → Encrypt with Password → clear the password → OK. Save the file.
Keyboard shortcuts
Protection Shortcuts
Excel Wizard — protection through smart formulas, not locks
Sheet protection is a workaround. The real fix for "someone might edit the wrong cell" is proper data validation, input warnings, and formula patterns that resist accidental change. Excel Wizard can restructure your workbook with these patterns automatically — safer than passwords, and no unlock-relock friction for legitimate users.
Install Excel Wizard →Frequently asked questions
How do I protect a sheet in Excel?
Go to Review tab, click Protect Sheet. Optionally enter a password. Choose which actions users can still perform (select cells, sort, use filters, etc.). Click OK. The sheet is now protected — locked cells can't be edited without unprotecting first.
What's the difference between Protect Sheet and Protect Workbook?
Protect Sheet prevents editing cells in a specific worksheet. Protect Workbook (Review → Protect Workbook) prevents structural changes to the workbook — adding/deleting/renaming/moving sheets. You often use both: Protect Workbook to lock the tab structure, plus Protect Sheet on individual sheets to lock content.
Can I protect a sheet without a password?
Yes. Leaving the password field empty still activates protection — users can't edit locked cells. But they can also click Unprotect Sheet without any password. A password only stops someone from unprotecting the sheet themselves. For casual protection, no password is fine; for anything sensitive, use a password.
How do I unprotect an Excel sheet without knowing the password?
There's no built-in way. If you own the file and forgot the password, there are third-party tools that can recover it, though we don't recommend them for anything other than files you legitimately own. For enterprise files, contact whoever created the protection. Excel's sheet protection is a mild deterrent, not real security.