Protecting Cells

Posted by Matthew Schmitt on May 09, 2001 6:34 AM

Is it possible to protect one column of a sheet instead of the whole thing? I have a formula that I don't want anyone touching, but data has to be entered in other areas of the sheet.

Posted by Mark W. on May 09, 2001 7:06 AM

Yes, just unlock all of the worksheet cells using
the Format | Cells... menu command's Protection
tab and then reapply the locked condition to the
column containing your formulas. When you
protect the worksheet using the Tools | Protection |
Protect Sheet... menu command your column of
formulas will be tamperproof.