How to delete all formulas in Excel fastest

When you use functions in Excel to process data, sometimes you want to delete all formulas in Excel to get the value of that formula or you want to delete all formulas because there are many jobs. Failed formula on Excel spreadsheet. So how do you delete all the formulas and keep the result values, or delete all the formulas and the result values? Please refer to the following article.

How to delete all formulas in Excel fastest Picture 1

Here are the fastest ways to delete all formulas in Excel, let's do the following:

Delete all formulas that keep the result in Excel

Step 1 : Click to select the upper left of the cells in Excel to select the entire Excel file or you can press Ctrl + A.

How to delete all formulas in Excel fastest Picture 2

Step 2: Right-click and select Copy ( Ctrl + C ).

How to delete all formulas in Excel fastest Picture 3

Step 3: Next, right click, in the Paste Options section, select the Values icon (V).

How to delete all formulas in Excel fastest Picture 4

So you have deleted all the formulas but still the whole results of that formula.

How to delete all formulas in Excel fastest Picture 5

Find and delete all formulas and results in Excel

If the Excel file contains a variety of data that you just want to find and delete all the cells containing the formula, while the other cells remain the same, you do the following:

Step 1 : Select the area or select all Excel files to delete the cells containing the formula, press Ctrl + G to open the Go To window .

How to delete all formulas in Excel fastest Picture 6

Step 2 : The Go To window appears, select Special .

How to delete all formulas in Excel fastest Picture 7

Step 3: On the Go To Special window, select Formulas and OK to Excel to find the cells that contain the formula.

How to delete all formulas in Excel fastest Picture 8

Step 4: Thus the cells containing the formula will be selected (highlighted) and the cells without formulas will automatically be deselected. To delete all formulas you just need to select the Delete key on the keyboard.

How to delete all formulas in Excel fastest Picture 9

Your results will be as follows:

How to delete all formulas in Excel fastest Picture 10

Above is the fastest way to delete all formulas in Excel, you will save maximum time to delete all formulas instead of selecting each data cell containing the formula and delete. Hope the article will help you. Good luck!