How to remove formula in Excel and keep values
You can watch a video tutorial here.
Excel is widely used for calculations and is very versatile when it comes to applying formulas. When we create a formula with cell references, the value will change each time the value in the cell it is dependent on changes. After creating a formula, you may want to retain only the computed value or the result and not the formula. For example, you create a column that is computed based on values in other columns and then have to delete the other columns. If this is done, the formulas will show an error because the source of the data is no longer available. In such a case, you will need to remove the formula from the computed column but retain the values.
Step 1 – Copy the cells
– Select the cells containing the formula
– Copy the cell by pressing Ctrl+C or by right-clicking and selecting Copy from the context menu
Step 2 – Open the Paste Special box
– Select the first cell of the same range as we want to paste the values in the same column
– Go to Home > Clipboard > Paste > Paste Special
Step 3 – Choose the Values option
– In the Paste Special window, choose Values
– Click OK
Note: After copying the data and selecting the destination, the keyboard shortcut for this paste operation is Alt+E > S > V or Ctrl+Alt+V
Step 4 – Check that the formulas have been removed
– Select any one of the cells and check the formula bar
– The formula is removed and only the value is displayed