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 is dependent on changes. After creating a column with formulas, you may want to copy only the computed value or the result and not the formula. For example, you create a column to compute a value and then need to copy that value to another table. In such a case, you will need to ensure that only the value is copied and not the formula.
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 cell to where the values are to be copied
– 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