How to protect the formular

[Guest]

I want to share a work book with my co-worker. I had set a formular in column
C. I want to allow that change only column A and B. How to protect the
formular in column C.

 

[Myrna Larson]

I want to share a work book with my co-worker. I had set a formular in column
C. I want to allow that change only column A and B. How to protect the
formular in column C.

Select all cells on the sheet. Go to Format/Cells/Protection and uncheck
"Locked". Then select just column C, again Format/Cells/Protection and check
"Locked". Then for this to take effect, it's Tools/Protection/Protect Sheet.