How to Lock Cells in Excel So Formulas Stay Put

Locking cells sounds like a single click, and that's exactly why so many people think it hasn't worked. In Excel it's a two-part job: you mark the cells as locked, then you switch on protection for the sheet. Until that second part happens, nothing is stopping anyone typing over your formulas.

If you share a quote calculator with a virtual assistant, or a booking tracker with a client, this is the trick that stops someone wiping out a formula by accident. Here's how it works, using Microsoft's own steps.

The Excel default that makes locking cells confusing

Microsoft says that by default, every cell on a sheet is already formatted as locked. That surprises people. It means that if you simply switch on sheet protection, the whole sheet freezes, including the boxes you wanted others to fill in.

So the real job usually runs backwards from how you'd expect. You clear the Locked setting on the input cells first, leave the formula cells locked, and then protect the sheet. Microsoft advises exactly that: free up any cells people need to change before you protect the sheet.

Locking specific cells in Excel for Windows

Here's the order I'd follow for a typical form or tracker where you want people to type in some boxes but not others.

1. Select the whole sheet, or the range you're working on.
2. On the Home tab, open the Format Cells window from the small launcher in the Alignment group.
3. Go to the Protection tab, untick Locked and select OK. That frees up every cell in your selection.
4. Now select only the cells you want to keep safe, such as your formulas and headings.
5. Open Format Cells again, tick Locked on the Protection tab and select OK.
6. Go to the Review tab and select Protect Sheet in the Protect group.
7. Add a password if you want one, choose what people can still do, and select OK.

Steps 1 to 3 are the bit most guides skip, and it's the reason a sheet can end up locked solid. If your sheet has lots of scattered input boxes, it can help to colour them in a light shade first, so you can see at a glance which ones still need the Locked tick removed. It also shows your team where they're meant to type once the file is protected.

Locking every cell on an Excel sheet

Sometimes you want the opposite: a finished report nobody should touch. Because every cell starts out locked, you can skip straight to the protection step. Go to Review, select Protect Sheet, set a password if you want, and select OK. That's it.

If you want to stop people adding, renaming or hiding tabs as well, that's Protect Workbook, which sits in the same Protect group on the Review tab. It locks the structure of the file rather than the cells.

Locked cells in Excel for the web and on a Mac

Microsoft's help says Excel for the web can't lock cells. If you're in the browser, select Open in Excel to switch to the desktop app, then follow the steps above.

On a Mac, the idea is the same: tick or untick Locked in Format Cells, then protect the sheet from the Review tab. Microsoft keeps a separate Mac article for this, and menu wording can vary a little by app version, so look for the Protection tab inside Format Cells.

Do you need a password to lock cells in Excel?

No. Microsoft says the password is optional. Without one, though, anyone can unprotect the sheet and change what you locked. Here's how I'd decide:

Situation	Password?
Your own template that you don't want to break by accident	Usually not needed
A tracker shared with a team or freelancer	Worth adding
A client-facing form where formulas must stay put	Add one and store it safely

If you do add a password, keep a record of it. Losing it means you'll struggle to edit your own locked cells later.

What locking cells in Excel won't do

Microsoft is very clear that worksheet-level protection isn't intended as a security feature. It stops people changing locked cells within the sheet, and that's all. It doesn't hide the data or stop anyone reading it.

So use locked cells to protect your formulas from slips, not to keep information private. If a sheet holds anything sensitive, think about who you share the file with in the first place.

Locking cells in Excel for shared business templates

This is where locking earns its keep for small businesses. A few ideas:

• Content calendars where your team fills in dates and titles, but the status formulas stay fixed.
• Order or stock sheets where a helper enters quantities and the totals can't be overwritten.
• Client onboarding forms where only the answer column is open.

If your team mixes Excel with Google, the browser version has its own tools. My guide to putting tick boxes in Google Sheets is handy for a shared to-do list, and the SUM steps for Google Sheets cover the totals you'd usually want to lock.

If your locked cells in Excel can still be edited

Run through these checks in order:

1. Is the sheet protected? Look on the Review tab. If you see Protect Sheet rather than Unprotect Sheet, the lock isn't switched on yet.
2. Are you on the right tab? Protection is set for each sheet separately.
3. Did you tick Locked on the right cells? Reopen Format Cells on one of them and check the Protection tab.
4. Are you in the browser? Excel for the web can't set locks, so open the file in the desktop app.

Frequently asked questions

Why can I still edit cells I locked in Excel?

Locking only takes effect once the sheet is protected. Go to the Review tab and select Protect Sheet, and the locked cells will stop accepting changes.

Are all cells locked in Excel by default?

Yes. Microsoft says every cell is formatted as locked by default, which is why you should untick Locked on the input cells before protecting the sheet.

Can I lock cells in Excel for the web?

No. Microsoft's help says Excel for the web can't lock cells. Select Open in Excel and do it in the desktop app.

Do I need a password to lock cells?

No, it's optional. Without one, anyone can unprotect the sheet and change the locked cells, so add one for shared files.

Is locking cells a way to keep data private?

No. Microsoft says worksheet protection isn't intended as a security feature. It stops changes to locked cells but doesn't hide anything.