Why are locked cells still editable in Excel?

Cell locking only works after the worksheet is protected. Go to Review > Protect Sheet to activate the locked setting.

How do I lock formulas but allow data entry?

Unlock the input cells, keep formula cells locked, then protect the worksheet.

Use it on one real task this week, then add a sticky note on your monitor with the shortcut until it becomes automatic.

Most shortcuts differ slightly on Mac (Cmd instead of Ctrl). Check the function or feature page for platform notes when something does not work.

Tips & Tricks - 2026-05-12

Learn how to lock formulas, protect sheets, unlock input cells, and prevent accidental edits in Excel without breaking workbook usability.

In Excel, cells are locked by default, but locking only takes effect after you protect the worksheet. This surprises many users. The typical workflow is: Unlock cells users should edit. Keep formula cells locked. Protect the sheet.

Select cells that users should be allowed to edit. Then go to: Format Cells -> Protection -> uncheck Locked These cells remain editable after sheet protection is turned on.

Formula cells should usually stay locked. To find formulas: Home -> Find & Select -> Go To Special -> Formulas Then confirm Locked is checked in Format Cells -> Protection.

Go to: Review -> Protect Sheet Choose what users can do, such as selecting unlocked cells, sorting, filtering, or formatting. Add a password only if needed. If you forget the password, recovery can be difficult.

When protecting a sheet, check Use AutoFilter if users need to filter a protected table. This keeps formulas safe while allowing normal report navigation.

Locked cells still editable because the sheet is not protected Input cells locked by accident Users cannot filter because filtering was not allowed during protection Passwords forgotten or not documented

Try the shortcut or setting on a copy of your file first. Pin the technique to your Quick Access Toolbar if you will use it daily. Pair productivity tips with Excel Tables and named ranges for fewer broken references. Explore: Tips archive · Keyboard shortcuts guide

Why are locked cells still editable in Excel? Cell locking only works after the worksheet is protected. Go to Review > Protect Sheet to activate the locked setting.
How do I lock formulas but allow data entry? Unlock the input cells, keep formula cells locked, then protect the worksheet.
How do I remember this Excel tip? Use it on one real task this week, then add a sticky note on your monitor with the shortcut until it becomes automatic.
Will this tip work on Mac Excel? Most shortcuts differ slightly on Mac (Cmd instead of Ctrl). Check the function or feature page for platform notes when something does not work.