Replace a formula with its result

You can replace part or all of a formula with the value calculated by that formula. Replacing a formula with its result can improve performance in a workbook with lots of formulas, or with complex formulas.

To replace a formula with its result, you copy the formula, press F9, and then press Enter.

Replace formulas with their calculated values

When you replace formulas with their values, Excel permanently removes the formulas. If you accidentally replace a formula with a value, click Undo Button image immediately after you enter or paste the value.

  1. Select the cell or range of cells that contains the formulas.

    If the formula is an array formula, select the range that contains the array formula. Otherwise, continue to step 2.

    To select a range that contains the array formula   

    1. Click a cell in the array formula.

    2. On the Home tab, click Find & Select, and then click Go To.

    3. Click Special.

    4. Click Current array.

  2. Press Ctrl+C to copy the cell or cells.

  3. Press F9, and then press Enter.

Top of Page

Replace part of a formula with its calculated value

At times, you may want to replace part of a formula with its calculated value. For example, you can lock in a down payment for a car loan.

When you replace a part of a formula with its value, that part of the formula can't be restored.

  1. Click the cell that contains the formula.

  2. In the formula bar Button image , select the portion of the formula that you want to replace with its calculated value. Make sure your selection includes the entire operand. For example, if you want to lock the result of a function, you must select the function name, its opening parenthesis, its arguments, and its closing parenthesis.

  3. To calculate the selected portion, press F9.

  4. To replace the selected portion of the formula with its calculated value, press Enter.

    If the formula is an array formula, press Ctrl+Shift+Enter.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×