Forum Discussion

Rick2304's avatar
Rick2304
Copper Contributor
Jan 24, 2024

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

excel
Formulas and Functions

3 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Jan 24, 2024
    Why would you delete all formulas because of some incorrect additions?

    F5
    Choose "Formulas"
    Press OK
    Press DEL
    • KarenKnopper's avatar
      KarenKnopper
      Copper Contributor
      Jan 24, 2024

      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.

      • peiyezhu's avatar
        peiyezhu
        Bronze Contributor
        Jan 25, 2024
        press
        Ctrl + ~

        show formula in cell then use find and replace with blank

Resources