| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
locking the cells
How can i lock the cells with formulas so that no one can edit that cell
either by writing in that cell or by any other means. Some people write in the cells with formulas and after that formulas disappear and only their text remains.Please help a.s.ap. -- Rajesh Chandra |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
locking the cells
Format/ Cells/ Protection/ unselect Locked, for those cells that you still
wish to be able to write into. Then Tools/ Protection/ Protect worksheet -- David Biddulph "Rajesh Chandra" wrote in message ... How can i lock the cells with formulas so that no one can edit that cell either by writing in that cell or by any other means. Some people write in the cells with formulas and after that formulas disappear and only their text remains.Please help a.s.ap. -- Rajesh Chandra |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking certain cells | Excel Discussion (Misc queries) | |||
| Locking Cells | Excel Worksheet Functions | |||
| Locking cells | Excel Worksheet Functions | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| Locking cells | Excel Discussion (Misc queries) | |||
Linear Mode
