| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to copy columns to sheet | Excel Discussion (Misc queries) | |||
| cannot group columns - get "cannot shift objects off sheet" help! | Excel Worksheet Functions | |||
| How do I reference non-contiguous columns in another sheet and th. | Excel Discussion (Misc queries) | |||
| Variable validation-password protect sheet | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
