| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to prevent editing within a specific cells?
Does anyone have any suggestions on how to prevent editing within a specific
cells? For example, in cell A1, there is a formula, =B1+C2. I don't want to delete this formula accidently, but I still can see this formula. Does anyone have any suggesitons on how to do it in excel? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to prevent editing within a specific cells?
Have you looked into the protection features in Excel? Under Tools, there is
a Protect sheet feature. The help topic covers all the different options you have, but this may get you what you need. "Eric" wrote: Does anyone have any suggestions on how to prevent editing within a specific cells? For example, in cell A1, there is a formula, =B1+C2. I don't want to delete this formula accidently, but I still can see this formula. Does anyone have any suggesitons on how to do it in excel? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| prevent pivot tables / charts from editing | Excel Discussion (Misc queries) | |||
| Protecting Check Boxes to prevent editing | Excel Discussion (Misc queries) | |||
| prevent user to delete specific sheets | Excel Discussion (Misc queries) | |||
| How do I prevent editing in a cell based on the value in another? | Excel Worksheet Functions | |||
| Prevent Printing of Specific Cells | Excel Discussion (Misc queries) | |||
Linear Mode
