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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks