Replace a formula with its result

You can replace a formula with its calculated value so that the formula no longer recalculates. Replacing a formula with its static result can help improve performance if the workbook contains many formulas or complex formulas. If you want to replace only part of a formula, you can replace only the part that you don't want to recalculate. You can convert formulas to their values on a cell-by-cell basis or convert a whole range immediately.

Replace a formula with its calculated value

Caution: When you replace a formula with its value, Excel permanently removes the formula. If you accidentally replace a formula with a value and want to restore the formula, click Undo  Undo icon immediately after you enter or paste the value. It's a good idea to make a copy of the workbook before replacing a formula with its results.

  1. Select the cell that contains the formula.

    If the formula is an array formula, select the range that contains the array formula.

  2. On the Home tab, click Copy.

  3. On the Home tab, click Paste.

  4. Click the arrow next to Paste Options  Paste Options button , and then click Values Only.

Caution: When you replace a formula with its value, Excel permanently removes the formula. If you accidentally replace a formula with a value and want to restore the formula, on the Standard toolbar, click Undo  Undo button immediately after you enter or paste the value. It's a good idea to make a copy of the workbook before replacing a formula with its results.

  1. Select the cell that contains the formula.

    If the formula is an array formula, select the range that contains the array formula.

  2. On the Standard toolbar, click Copy Copy button .

  3. On the Standard toolbar, click Paste Paste button .

  4. Click the arrow next to Paste Options  Paste Options , and then click Values Only.

Replace part of a formula with its calculated value

Caution: When you replace part of a formula with its value, it cannot be restored.

  1. Select the cell that contains the formula.

  2. In the formula bar, select the part of the formula that you want to replace with its calculated value.

    Note: When you select the part of the formula that you want to replace, make sure that you include the whole operand. For example, if you select a function, you must select the whole function name, the opening parenthesis, the argument, and the closing parenthesis.

  3. Press COMMAND + = .

    Excel calculates the selected part of the formula.

  4. Press RETURN.

    If the formula is an array formula, press COMMAND + RETURN.

    Excel replaces the selected part of the formula with its calculated value.

See also

Change formula recalculation, iteration, or precision

Copy and paste specific cell results

Switch between relative and absolute references

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×