Post actualizado el día octubre 24, 2026 by DeiviSanzPlay
Locking cells in Excel often causes confusion because the «Lock Cell» button in the Format menu does nothing on its own. If you enable it and keep typing in the cell, it’s not your mistake: Excel has two layers that you must activate in order. First you mark which cells are locked, and then you protect the sheet so that the lock takes effect.
The order that almost no one explains at the beginning
Most tutorials jump straight to «Review > Protect Sheet.» The problem is that, by default, all the cells in a new sheet are already marked as locked. If you protect the sheet without changing anything, the user won’t be able to edit absolutely anything. That’s the most common mistake I see when someone is starting out: protecting first and unlocking afterward, when the logical thing is the opposite.
Step 1: unlock what should actually be editable
- Select the cells you want to leave editable (for example, B2:B10 in an expense template).
- Press Ctrl+1 to open Format Cells.
- Go to the Protection tab and uncheck Locked. Click OK.
If you prefer the menu, under the Home tab > Format > Format Cells you’ll get to the same place. The Ctrl+1 shortcut is faster and works in Excel for desktop, Excel for the web, and the Mac version.
Step 2: protect the sheet
Now you can: Review > Protect Sheet. Excel will ask you for a password (optional, but recommended if you’re going to share the file). In the options box you can allow specific actions such as selecting locked cells, sorting, or filtering. If you uncheck everything, the user will only be able to move around the sheet, not modify anything.
Practical case: a schedule template
Imagine a sheet with employee names in column A and shifts in B2:H20. You want whoever fills it in to be able to enter the shifts but not delete the names or the total formulas. The sequence would be: unlock B2:H20, leave A2:A20 and the totals row locked, and protect the sheet allowing only «Select unlocked cells.» One detail that gets overlooked: if the sheet has hidden rows or grouped columns, protection also affects them, and the user may find that they can’t expand a group even though the cells are unlocked.
What this feature doesn’t solve
Sheet protection in Excel is an editing barrier, not real security. According to Microsoft’s official documentation, it isn’t intended to encrypt data or to prevent someone from copying the content. Anyone with basic knowledge can copy the cells to another workbook and bypass the lock. If you really need to protect sensitive information, the way to go is to encrypt the file with a password (File > Info > Protect Workbook) or use restricted access permissions.
Limitations you should know about
- The sheet password can be lost and there’s no official recovery: write it down.
- Protecting the sheet doesn’t protect the workbook: new sheets added later don’t inherit the protection.
- Macros can bypass protection if the user enables them; it’s not an absolute lock.
- In Excel for the web, unlocking cells works, but some advanced protection options are only available in the desktop version.
A mental shortcut so you don’t get confused
Think of two switches: the cell one (locked or not) and the sheet one (protected or not). The lock only takes effect when the sheet is protected. If you ever protect a sheet and everything turns gray, first check whether you unlocked the cells beforehand; almost always the problem is there and not with the password.
