| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
Is there any way to lock a cell once a formula has been placed in it so it
can not be changed accidentally? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
1. Select entire worksheet by clicking the Select All button, (the grey
rectangle directly above the row number for row 1 and to the left of column letter A) 2. Click Cells on the format menu, click the Protection Tab, and clear the LOCKED check box. 3. Select the cells you want to lock and repeat step 2, but this time select the LOCKED check box. 4. Go to tools menu, point to Protection, and click Protect Sheet. Then OK. Hope this solves your problem.. "Eric" wrote: Is there any way to lock a cell once a formula has been placed in it so it can not be changed accidentally? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Hybrid Mode
