Picture this: you've spent hours crafting the perfect spreadsheet, and your coworker Kevin accidentally deletes your formulas. Kevin. Again. To prevent Kevin-related tragedies, you need to lock certain cells in Excel so only you control what changes.
First Things First: Unlocking Is Actually Locking
Confusing? Absolutely. By default, Excel already treats every single cell as locked — but here's the catch: that formatting does nothing until you protect the sheet. It's like locking your car and forgetting to close the windows.
So the real magic happens when you protect the worksheet. Once protection is on, only cells you've marked as unlocked become editable. Think of it as VIP access at a club — most cells are still waiting in line outside.
Must Read
Step One: Choose Your Unlocked Champions
Start by selecting the cells you want people to actually be able to edit. Grab your mouse like a sword and drag across those input fields, dropdowns, or whatever y')
Wait — let's keep this simple: select the cells meant for changing, such as input boxes or data entry areas. Everything else (formulas, headers, beautiful stuff you built with love) stays locked by default. Congratulations, you just made Kevin's job much harder.
Locking and Unlocking Cells in Excel A Quick Guide | Updated 2026
Step Two: Remove the Lock
Right-click those selected cells and choose Format Cells. Navigate to the Protection tab — it's hiding back there like a shy introvert at a party. Uncheck the Locked box and hit OK, magic hand.
Now only the cells you selected are free to roam. Everything else remains sealed behind an invisible digital wall. Kevin is crying.
Step Three: The Grand Protection Finale
Head over to the Review tab and click Protect Sheet. You'll see options letting you choose exactly what users can do — sorting, selecting locked cells, formatting, you name it. You can even set a password, though choosing "password" is strongly encouraged.
How To Lock Certain Cells In Excel Sheet - Design Talk
Excel will ask you to confirm that password because it's suspicious of you — and rightfully so. Type it in, hit OK, and your sheet is officially locked down. Cell protection is active, FBI-style.
Pro Tips From the Trenches
Want to protect an entire workbook? Go to Review, click Protect Workbook, and even your annoying sheet-tabs are now safe. Nobody's dragging, renaming, or "accidentally" deleting your hidden sheet named Total_Secret.
How to Lock Cells in Excel (with Pictures) - wikiHow
Here's a wild fact: molecular biologists once used Excel in peer-reviewed research until autocomplete mangled gene names into dates. Let's not make that kind of headline in your office.
Unlocking When You Need To
To make changes later, simply unprotect the sheet under the Review tab. If you set a password, you'll need it — there's no "Forgot Password" link, so write it somewhere unforgettable. Like inside your desk drawer, or tattooed on your arm; your call.
And that's it! You now know how to lock cells, protect sheets, and secure your workbook like a spreadsheet superhero. Go forth, guard those formulas, and make Kevin think twice. Your spreadsheets were always worth protecting.