Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i prevent a formula in excel from being deleted?
I have created a simple sheet with formulas. I want to protect the formulas
so that if a figure is entered, then deleted, the formular still stays there. I have tried to use the help menu, but doing the suggested protections makes it so the figure cant even be entered into the cell! Thank-you for your help! |
#2
|
|||
|
|||
you need to have an input cell(s) seperate from your formula so instead of
4*2 typed in a cell have 4*A2.Then you cam lock your formula but leave your input cel unlocked...protect the sheet and your formula will be safe..... -- paul remove nospam for email addy! "Sarah" wrote: I have created a simple sheet with formulas. I want to protect the formulas so that if a figure is entered, then deleted, the formular still stays there. I have tried to use the help menu, but doing the suggested protections makes it so the figure cant even be entered into the cell! Thank-you for your help! |
#3
|
|||
|
|||
Thanks paul... but i have no idea what you mean!! The formulas I have are
autosum formulas and one "IF" formula. (ie =SUM(E12:H12) and =IF((SUM(D6:D27))=(SUM(E28:H28)),SUM(D6:D27),"INCO RRECT!!")) So what i want to do is make it so figures can be entered in these cells, but if a person decides to delete the figure they entered, the formula doesn't get deleted too. Hope this makes sense and you can help me!! Thank-you Sarah "paul" wrote: you need to have an input cell(s) seperate from your formula so instead of 4*2 typed in a cell have 4*A2.Then you cam lock your formula but leave your input cel unlocked...protect the sheet and your formula will be safe..... -- paul remove nospam for email addy! "Sarah" wrote: I have created a simple sheet with formulas. I want to protect the formulas so that if a figure is entered, then deleted, the formular still stays there. I have tried to use the help menu, but doing the suggested protections makes it so the figure cant even be entered into the cell! Thank-you for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula in an Excel comment | Excel Discussion (Misc queries) | |||
Excel should have a simpler subtraction formula similar to "sum". | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |