Table of Contents

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. To copy a formula result to another cell simply paste as values. 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.

Leave A Comment

Excel meets AI – Boost your productivity like never before!

At Formulas HQ, we’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Say goodbye to the days of grappling with complex formulas, VBA code, and scripts. We’re here to make your work smarter, not harder.

Related Articles

The Latest on Formulas HQ Blog