How to protect the formular

J

joy

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.
 
M

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.
Click to expand...

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.
 
Top