I've got a calc sheet for calculating some grades.
Hence, after setting all the formulas (you may want to have a look at the SUMPRODUCT(notes*percent) function ;-) ), I want to actually enter the grades I gave.
What I want to do is not to mess around with the cell containing formulas while I am entering data.
How to (un)-lock specific cells
- Select the cell you want to still modify.
- right-click: Format-Cells -> "Cell Protection" tab => uncheck "protected".
- Tools -> Protect Document -> sheet
- Uncheck "select locked cells" and check "select unlocked cells".
Now only the cells selected in step 1) should be the only ones you can select and modify !
