The use of functions in excel or formulas in Excel is indispensable and very basic to perform other data or other data processing requirements. And if you want more compact excel, you can hide the formula quickly on Excel with many other methods. You do not need to adjust the formula for each region or each umbrella but can quickly hide the entire Excel formula. Below is a guide to delete the formula on Excel.
Instructions to delete formulas in Excel 2019 and above
Delete the formula to keep the results by copy & paste
Step 1:
First of all you need Choose cells or range containing formulas. We can also press the Ctrl + A key combination to select the entire data sheet.
Step 2:
After selecting the data table, press Ctrl + C, or left mouse Select Copy In the display list.
Step 3:
Next to the user right -click, Paste Options section select icon 123 As shown.
The results of the total number of the number show only the results and no formula as below.
Delete the Excel formula by dragging mice
First you choose the formula area, then Place the mouse pointer at the edge of the selected area until Show 4 sides arrows. Right -click and pull the selected area to an empty position Then drop the mouse. Then will display the menu selected as shown, Press copy here as values only.
The result will copy a cell containing the result of no formula. Now you just need to move it on top.
How to delete the Excel formula using Paste Special
Step 1:
We also black up the area to delete the formula, then Click Copy and then press Paste Special In Paste, or right -click Paste Special.
Step 2:
In the display interface you Choose in Values boxunder Select None To delete the formula in the data table is okay.
Instructions to delete the formula on Excel 2007
Delete the formula Excel to keep the results
Step 1:
Let's blacken all the data tables on Excel to process the formula.
Step 2:
Next, right -click to select Copy To copy the table. Press next Paste Special In the list.
Step 3:
New dialog box interface appears. At the Paste Management section selected Values Then click OK.
Step 4:
Returning to the table will see the flashing lines. Just right -click on the empty area outside the data board and then choose Clear Contents is okay.
The results of the formula formula will not appear the formula but only the results.
With Excel 2010 or higher, the simple way is that you also black up the data board, also click Copy to copy, click right mouse and in the section Paste Options Select the Values icon (V) as shown to delete the formula.
Delete all formulas and results Excel
In case the Excel file has many types of data that we just want to find and delete all cells containing the formula, while other cells keep the same way, this method can be applied.
Step 1:
We also choose all areas containing the formula to be deleted and then select Ctrl + G key combination. There is a big goal dialog box. Here you should click on Special button.
Step 2:
In the Go To Special dialog box you choose Formulas To select all the content related to the formula and click OK so that Excel to find the cell contains the formula.
Step 3:
Then you will see the formula containing the formula framing As shown below for easy identification compared to the data cells that do not contain the formula in the table. Finally, you just need to press the Delete key to delete those formulas.
Depending on the needs of editing formulas on Excel, we can choose how to delete the formula, retain the results or delete the entire formula and results. The above method will save more time when choosing each data cell containing the formula to delete.
See also:
I wish you success!
