How to Lock Cells in Excel
Learn how to lock cells in Excel, unlock editable cells, protect a sheet, avoid common mistakes, troubleshoot, and use FAQs.
Quick Answer
To lock cells in Excel, select cells that should remain editable and unlock them, then protect the sheet. Excel cells are locked by default, but locking only takes effect after sheet protection is turned on.
What You Need
- Excel workbook
- Cells to protect
- Cells users may edit
- Review tab access
- Optional password
Safety Precautions
- Save a backup before protecting important workbooks.
- Do not forget the password if you set one.
- Unlock editable input cells before protecting the sheet.
- Protection is for preventing accidental edits, not strong security.
- Test the sheet as a user before sharing.
Step-by-Step Instructions
- Step 1
Plan editable cells
Decide which cells users should be allowed to change.
- Step 2
Select editable cells
Highlight cells that should remain editable.
- Step 3
Open Format Cells
Right-click, choose Format Cells, and open the Protection tab.
- Step 4
Unlock editable cells
Uncheck Locked for cells users can edit.
- Step 5
Protect sheet
Go to Review > Protect Sheet.
- Step 6
Choose permissions
Select what users may do, such as selecting unlocked cells.
- Step 7
Test protection
Try editing locked and unlocked cells to confirm behavior.
Practical Example
Example: In a budget template, you unlock the monthly input cells, protect the sheet, and keep formulas locked so users do not overwrite them.
Common Mistakes
- Locking cells without protecting the sheet
- Forgetting to unlock input cells
- Using protection as strong security
- Forgetting the password
- Protecting the wrong sheet
- Not testing before sharing
Troubleshooting
Users can still edit locked cells
Turn on Review > Protect Sheet.
Users cannot edit input cells
Unprotect, unlock those cells, then protect again.
Password is forgotten
Use your backup; do not rely on sheet protection for critical security.
Macros or filters stop working
Adjust protection permissions before sharing.
Helpful Internal Links
FAQs
Why are cells still editable after locking?
Cell locking only works after protecting the sheet.
Are Excel locked cells secure?
They help prevent accidental edits but are not strong security.
Can I let users edit only some cells?
Yes, unlock those cells first, then protect the sheet.
Can I lock formulas?
Yes. Keep formula cells locked and protect the sheet.
Related Guides
How to Lock Row in Excel
Learn how to lock a row in Excel with Freeze Panes, keep headers visible, avoid mistakes, troubleshoot, and understand protection vs freezing.
How to Add Drop Down List in Excel
Learn how to add a drop down list in Excel using Data Validation, source lists, error alerts, common mistakes, troubleshooting, and FAQs.
How to Calculate Volume
Learn how to calculate volume for boxes, cylinders, and simple shapes, choose the right formula, avoid unit mistakes, troubleshoot, and use FAQs.
Help us improve this guide
Tell us about an outdated instruction, unclear step, broken link or safety concern. Do not include passwords, account numbers, medical records or other sensitive information.