How do i lock formulas in a spreasheet?

[4ngi3]

Hi,

I created a spreadsheet for my invoicing but I keep accidently deleting the formulas and having to reinput them again.

Is there a way I can lock all the formulas?

Thanks,
Angie

[JBeaucaire]

1) Highlight the cells you want to be able to edit
2) Press CTRL-1 to open the "format cells" window
3) On the PROTECTION tab, uncheck the "Locked" option.

4) No protect the sheet. Tools >> Protection >> Protect Sheet... set whatever advanced settings you want.


Now the cells you unlocked are editable, the rest are not.