spot_img

Formula to Value

 

To quickly convert a formula to a value in Excel or to convert multiple formulas to values, execute the following steps.

1. Select a cell with a formula.

Formula in Excel

2. Press F2 to switch to editing mode.

Editing Mode

3. Press F9 to replace this formula with its result.

Convert Formula to Value

Don’t forget to press Enter. Use the following magic trick to quickly convert multiple formulas to values in Excel.

4. Select a range of cells containing formulas. Hover over the right border of the selection. A four-sided arrow appears.

Formulas

5. Click and hold the right mouse button. Drag the box to the right.

Drag Box to the Right

6. Keep holding down the right mouse button. Drag the box back to its original position.

7. Release the right mouse button. From the popup-menu, click Copy Here as Values Only.

Copy Here as Values Only

Result:

Formulas to Values

Note: cell D1 contains the value 30 (not a formula), cell D2 contains the value 60 (not a formula), etc.

spot_img
Previous articleCreate Drop-down Lists in Excel
Next articleGoal Seek in Excel