You can replace a formula with its calculated value so that it no longer recalculates. If you want to replace only part of a formula, you can replace only the part that you don't want to recalculate.
Do any of the following:
 | Replace a formula with its calculated value |
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 immediately after you enter or paste the value.
Select the cell that contains the formula.
If the formula is an array formulaA single formula that performs multiple calculations and then returns either a single result or multiple results. Array formulas act on two or more sets of values, known as array arguments. Each array argument must have the same number of rows and columns. To return multiple results, the formula must be entered into multiple cells.
When you enter an array formula by pressing ⌘+RETURN. Excel automatically encloses the array formula between braces ( { } )., select the range that contains the array formula.Click Copy
.
Click Paste
.
Click the arrow next to Paste Options
, and then click Values Only.
| Replace part of a formula with its calculated value |
When you replace part of a formula with its value, it cannot be restored.
Select the cell that contains the formula.
In the formula barA toolbar that you use to enter or edit values or formulas in cells or charts. The formula bar displays the constant value or formula used in the active cell.
, select the portion of the formula you want to replace with its calculated value.
Note When you select the part of the formula you want to replace, make sure to include the entire operandItems on either side of an operator in a formula. In Excel, operands can be values, cell references, names, labels, and functions.. For example, if you select a function, you must select the entire function name, the opening parenthesis, the argumentsA value that a function uses to perform operations or calculations. The type of argument that a function uses is specific to the function. Common arguments used within functions include numeric values, text values, cell references, ranges of cells, names, labels, and nested functions., and the closing parenthesis.
Press ⌘+=.
Excel calculates the selected portion of the formula.
Press RETURN.
If the formula is an array formulaA single formula that performs multiple calculations and then returns either a single result or multiple results. Array formulas act on two or more sets of values, known as array arguments. Each array argument must have the same number of rows and columns. To return multiple results, the formula must be entered into multiple cells.
When you enter an array formula by pressing ⌘+RETURN. Excel automatically encloses the array formula between braces ( { } )., press ⌘+RETURN.Excel replaces the selected portion of the formula with its calculated value.
