Buzz
Step 1: Click on the upper left corner of the cells in Excel to select the entire Excel file or you can press the keyboard shortcut Ctrl + A.
Step 2: Right-click and select Copy (Ctrl + C).
Step 3: Next, right-click again, in the Paste Options section, select the Values icon (V).
Thus, you have deleted all formulas while retaining the original results of those formulas.
Locate and delete all formulas and results in Excel
If your Excel file contains various data types and you only want to find and delete cells containing formulas while keeping others intact, follow these steps:
Step 1: Select the range or the entire Excel file where you want to delete cells containing formulas, then press Ctrl + G to open the Go To window.
Step 2: In the Go To window, select Special.
Step 3: In the Go To Special window, select Formulas and click OK for Excel to locate cells containing formulas.
Step 4: Consequently, cells containing formulas will be selected (highlighted), while those without formulas will be automatically deselected. To delete all formulas, simply press the Delete key on the keyboard.
The result will be as follows:
Above is the fastest way to delete all formulas in Excel, saving you maximum time compared to selecting each cell containing a formula individually. Hopefully, this article will be helpful to you. Wish you success!
