- Select all cells(Ctrl + A) in a worksheet.
- Right Click -> Format Cells -> Protection -> Uncheck locked.
- Select the cells you want to lock
- Right Click -> Format Cells -> Protection -> Check locked.
- Go to Review -> Protect Sheet -> Add password -> Re-enter password
- Locked cells cannot be changed.
- To unlock, go to Review -> Protect Sheet -> Enter password
How to lock cells in Excel
Last updated at March 28, 2017 by Teachoo