Ever gotten this look on a spreadsheet? You lock a cell… and folks still change it.
Here’s the real deal on how to lock a cell in Excel so it actually stays uneditable peace, no sweat.
What “lock a cell” even means
Quick tip: In Excel, cells are “locked” only after you protect the sheet. That sounds weird. But it’s true.
So before Excel can stop changes… you gotta turn on the sheet lock.
Here’s how it really works:
Step-by-Step
- Select the cell you want locked
Click it like you’re picking tea over coffee. - Open Format Cells
Right-click → Format Cells (or hit Ctrl+1) quick shortcut. - Go to the Protection tab
Check Locked and hit OK. - Protect the sheet
Go to Review → Protect Sheet → OK.
You can add password… if you want it really locked.
Done.
Now that cell won’t take edits. Simple as that.
Here’s the catch though if you try locking before protecting the sheet… nothing changes. Nada. Totally normal, don’t panic.
Real Story
My buddy Ravi shared his budget sheet with teammates.
He ticked “Locked” on the totals cell…
But people still typed over it.
He went back and hit Protect Sheet boom problem gone.
That little missed click costs way more time than it should. Totally human, right?
When you want only “some” cells locked
Most guides make you unlock all cells first weird, right?
Here’s the quick pattern:
- Select all (Ctrl+A) → unlock everything
- Then select the few cells you actually want locked
- Mark those as Locked → Protect Sheet
It feels backward. It totally is. But it works.
Lock just ONE cell (quick list)
- Click your cell
- Right-click → Format Cells
- Go Protection tab → tick Locked
- Review → Protect Sheet
- Set password (optional)
Boom locked for real.
Common oops & fixes
“Hey, it’s still editable!”
Yep, that’s because sheet protection wasn’t turned on. Go click Protect Sheet that’s the magic switch.
“I locked it but forgot password!”
In short there’s no reset button. If you set a password, remember it.
“I only want formulas locked, others editable.”
Unlock all first → select formulas → mark locked → protect sheet. Excel then guards only the formulas.
FAQ‘s
Q: Will people see the locked cell contents?
A: Yeah locking stops editing, not viewing.
Q: Can I lock cells without protecting sheet?
A: No. The lock isn’t active until sheet protection is on.
Q: What if I want to share this sheet but still let some edits?
A: Unlock the cells you want people to edit first then protect sheet.