Formulas keep clearing out, how to stop that
- Thread starter rjwalters
- Start date
Hey rjwalters,
I generally use this method to protect cells with formula.
Select the entire range where formula and data resides. Right click and select Format Cells. Under Protection tab uncheck Locked.
Again select only those cells where the formula is and select Format cells and under protection select Locked.
Now Under review select protect sheet and apply a formula if you would like to.
Hope this helps
I generally use this method to protect cells with formula.
Select the entire range where formula and data resides. Right click and select Format Cells. Under Protection tab uncheck Locked.
Again select only those cells where the formula is and select Format cells and under protection select Locked.
Now Under review select protect sheet and apply a formula if you would like to.
Hope this helps
NARAYANK991
Excel Ninja
Hi Walters ,
Another option depends on how you are clearing the data in your worksheet.
Suppose you press F5 or CTRL G , and bring up the Go To dialog box ; click on the Special button , and click the Constants option button ; uncheck the Text check box , since otherwise even your headers will be selected. Press the Del button to delete all of the data.
Your formulae will remain.
Narayan
Another option depends on how you are clearing the data in your worksheet.
Suppose you press F5 or CTRL G , and bring up the Go To dialog box ; click on the Special button , and click the Constants option button ; uncheck the Text check box , since otherwise even your headers will be selected. Press the Del button to delete all of the data.
Your formulae will remain.
Narayan
SirJB7
Excel Rōnin
Hi, rjwalters!
Give a look at this file:
https://dl.dropbox.com/u/60558749/Formulas%20keep%20clearing%20out%2C%20how%20to%20stop%20that%20%28for%20rjwalters%20at%20chandoo.org%29.xlsm
It does what you asked for, but I think it's not enough yet, e.g., check titles before and after clearing range. BTW it'd be slow for huge ranges, I guess, if it's your case just try it see what happens.
Just advise if any issue.
Regards!
Give a look at this file:
https://dl.dropbox.com/u/60558749/Formulas%20keep%20clearing%20out%2C%20how%20to%20stop%20that%20%28for%20rjwalters%20at%20chandoo.org%29.xlsm
It does what you asked for, but I think it's not enough yet, e.g., check titles before and after clearing range. BTW it'd be slow for huge ranges, I guess, if it's your case just try it see what happens.
Just advise if any issue.
Regards!