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