How to Lock Cells in Excel
Every Excel cell is locked by default, but that setting does nothing until you protect the sheet. Here's the two-step process to keep specific cells editable.
Every cell in Excel already has its Locked property turned on, but that lock is inactive until you protect the worksheet from the Review tab - on an unprotected sheet, locked cells edit just like any other. The real work is deciding which cells should stay editable, unlocking only those through Format Cells > Protection, and then protecting the sheet to make the remaining lock take effect. Get that order backward and you’ll either lock down a sheet that still lets people type anywhere, or protect it before opening up the cells people actually need.
Why “Locked” Doesn’t Lock Anything by Itself
Microsoft’s own documentation puts it plainly: cells are “already locked,” meaning they’re “ready to be locked when you protect the workbook or worksheet.” Locking is a per-cell property that stays dormant until protection is switched on - it’s not an action that happens the moment you check a box. That’s why people who check Locked in Format Cells and see no change aren’t doing anything wrong; the sheet just isn’t protected yet. See Microsoft’s cell-locking reference for the full breakdown.
Step 1: Unlock the Cells People Should Still Edit
Do this before you protect anything, since every cell starts locked by default:
- Select the cell, column, or range that should stay editable - input fields, comment boxes, whatever people need to fill in.
- Press Ctrl+1, or right-click the selection and choose Format Cells.
- Open the Protection tab.
- Clear the Locked checkbox, then select OK.
Repeat for every range that needs to stay open. Anything you skip keeps its default Locked status and becomes read-only the moment protection is on.
Step 2: Turn On Protection From the Review Tab
Locking only takes effect once you flip this switch:
- Go to the Review tab and select Protect Sheet (in the Protect group).
- Optionally set a password. Anyone without it can’t remove protection through the menu, but this isn’t encryption - treat it as a deterrent for casual edits, not a real security control.
- In the dialog, check off which actions to still allow on the protected sheet - selecting unlocked cells, sorting, using AutoFilter, and so on - then select OK.
From this point, locked cells reject direct edits and unlocked ones behave normally. Note that Protect Workbook is a different command: it guards the structure of the file (adding, deleting, hiding, or renaming sheet tabs), not the content of individual cells, so it won’t do what Protect Sheet does.
Excel Cell Locking, Symptom by Symptom
| Symptom | Likely cause | Fix |
|---|---|---|
| Every cell is still editable after “protecting” | You used Protect Workbook instead of Protect Sheet | Go to Review > Protect Sheet, not Protect Workbook |
| Cells you meant to leave open are locked too | Protection was turned on before you unlocked that range | Unprotect the sheet, clear Locked on that range in Format Cells > Protection, reprotect |
| Formulas keep getting overwritten | The sheet was never protected, so the default Locked property never activated | Confirm which cells are unlocked, then run Protect Sheet |
| Can’t remove protection | A password was set and forgotten | Excel has no built-in password recovery; only the original password removes it |
For a shared budget, roster, or team template, the pattern is the same every time: lock the formulas and headers by leaving their default state alone, unlock just the input cells, then protect the sheet with a password only if you need to stop people from turning protection off entirely. If the sheet also collects picks from a drop-down list or feeds a VLOOKUP lookup elsewhere, locking the surrounding cells keeps editors inside the boundaries you built the sheet around instead of typing over the parts that make it work.