How can I protect certain columns on a sheet so that formulas are.

T

Tan

How do I go about protecting certain columns on an excel sheet so that
formulas are not changed by someone else entering data onto the worksheet
 
J

jiwolf

Right click on the cells you want to allow data entry in. Then select
"format cells", Then "protection". uncheck the "locked" box. Then protect
the worksheet.
 
Top