You don't need to adjust the formula hiding settings for each range or cell; you can quickly hide all Excel formulas. Below are instructions on how to remove formulas in Excel.
Instructions on how to delete formulas in Excel 2019 and later versions.
Delete Excel formulas while keeping the results by copying and pasting.
Step 1:
First, you need to select the cell or range containing the formula . We can also press Ctrl + A to select the entire data table.
Step 2:
After selecting the data table, press Ctrl + C, or left-click and select Copy from the displayed list.
Step 3:
Next, the user right-clicks, selects the 123 icon in the Paste Options section, as shown in the image.
The total quantity cell only displays the result and does not show the formula, as shown below.
Delete Excel formulas by dragging and dropping.
First, select the formula area, then place the cursor at the edge of the selection until a four-sided arrow appears. Right-click and drag the selection to an empty space, then release the mouse. A selection menu will then appear as shown in the image; click "Copy Here as Values Only ".
The result will copy one cell containing the result without a formula. Now you just need to move that cell up.
How to delete Excel formulas using Paste Special
Step 1:
We also highlight the area where we want to delete the formula, then press Copy, and then press Paste Special in the Paste section, or right-click and select Paste Special.
Step 2:
In the displayed interface, check the Values box , then select None below to remove the formula from the data table.
Instructions on how to delete formulas in Excel 2007
Delete Excel formulas while keeping the results.
Step 1:
Let's highlight all the data tables in Excel that we want to process with formulas.
Step 2:
Next, right-click and select Copy to copy the table. Then click Paste Special in the list.
Step 3:
A new dialog box will appear. In the Paste management section, select Values and then click OK.
Step 4:
Returning to the table, you'll see some blinking dashed lines. Simply right-click on the empty area outside the data table and select Clear Contents .
The result of the original sum formula cell will no longer display the formula, only the result.
With Excel 2010 and later versions, the process is simple: highlight the data table, click Copy to copy, right-click, and in Paste Options select the Values icon (V) as shown in the image to delete the formula.
Delete all Excel formulas and results.
This method can be used if your Excel file contains various types of data and you only want to find and delete cells containing formulas, while keeping others unchanged.
Step 1:
We also select all the areas containing the formulas we want to delete, then press Ctrl + G. A Go to dialog box will appear. Here, click the Special button .
Step 2:
In the Go To Special dialog box, select Formulas to choose all the content related to the formula, and then click OK to have Excel find the cell containing the formula.
Step 3:
Then you will see the cells containing the formulas framed as shown below, making them easier to distinguish from the data cells without formulas in the table. Finally, simply press the Delete key to remove those formula cells.
Depending on your needs for editing formulas in Excel, you can choose to delete the formula, keep the result, or delete the entire formula and its result. This method saves time compared to having to select each cell containing the formula to delete it.
You've just finished reading the article "How to quickly delete formulas in Excel - Keep the results or delete the results" edited by the TipsMake team. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.