Protecting formulas
 

Hello,
I've been working on a daily log for the guys that work with me. I was
wondering if there is a way to protect formulas in a cell. So if the guys hit
delete or such they will not delete the formula. So all my calculations will
be correct. But I still need it to where the guys can still add info in those
cells.
Thanks,
Shaunna

Protecting formulas
 

If you have a formula in the cell, and it is typed in, the formula would then
be removed. If you are OK with this, there is no way to allow the cell to be
typed in but not deleted.

If you want to protect/unprotect only certain cells, go to Format - cells -
Protection and select/deselect Locked. Then Go to Tools - Protection -
Protect sheet.

"Shaunna" wrote:



Hello,
I've been working on a daily log for the guys that work with me. I was
wondering if there is a way to protect formulas in a cell. So if the guys hit
delete or such they will not delete the formula. So all my calculations will
be correct. But I still need it to where the guys can still add info in those
cells.
Thanks,
Shaunna