Forum Discussion
How to clear all formulas from Excel. Recently the simple addition sums in columns are incorrect.
How do I clear all formulas from Excel? Recently, the simple addition sums in columns are incorrect. How do I prevent this from reoccur
Why would you delete all formulas because of some incorrect additions?
F5
Choose "Formulas"
Press OK
Press DEL
F5
Choose "Formulas"
Press OK
Press DEL
this isn't about deleting formulas but rather how to get them to work. Autosum suddenly isn't working. I've tried everything I can think of to make it work but to no avail.
- press
Ctrl + ~
show formula in cell then use find and replace with blank
