How to lock a excel farmula

[Rickey_10]

need to know how to lock a formula in a excel worksheet

 

[JordoR]

Wrong area... but I'll still answer you

- Right click on the cell that you want to lock
- Navigate to the protection tab
- Make sure the "Locked" box is checked if you want the formula to be uneditable.
- Make sure the "Hidden" box is checked if you also want to not display the formula

Then select OK, go to the Review Tab in excel, select protect sheet, enter your password and that's about it.

Let me know if you have any problems. Not sure which version of Excel you are using, they vary slightly.

 

[Mousemonkey]

This topic has been moved from the section CPU & Components to section Applications by Mousemonkey