Cell protection

Hi Mike,

Thank you for your question.

In order to protect a cell with a formula, go to Tools - Allow users to Edit Ranges.

Click New and type a name for that cell. In the Range Refers to box, select the cell with the formula in and then type in a password in the final box.

Then use the Protect Sheet button in the bottom left of the box and type a password in.

All the cells are now password protected. To edit the spreadsheet you would need to unprotect the whole sheet. If you just want to edit the cell with the formula in, you need to put that cell formula you set up earlier.

I hope this answers your question.

Regards

Simon