Locking a spreadsheet's cells is a two-step process.
- Select cells to unlock.
- Lock the worksheet.
By default, cells are set to "Locked". You will want to unlock cells that you want to be able to be edited.
Select the cell(s) that you wish to unlock, right click, and select Format Cells...
Select the Protection tab.
Uncheck the box beside Locked and click the "OK" button.
Once you have all of the cells unlocked that you desire, you can now lock the spreadsheet.
On the worksheet tab, right click and select Protect Sheet...
Type in a password and click the "OK" button.
Reenter your password and click the "OK" button.
Success!
If you try to type into one of the locked cells, a warning message will appear.
If you need to unlock the worksheet, right click on the worksheet and select Unprotect Sheet...
Type in the password and click the "OK" button.
