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

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

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.

"Tan" wrote in message
...
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