Subscribe

Lesson 76 of 104 3 min Updated Completed

How to Convert Formulas to Values

Sometimes you want to keep a formula’s result but remove the formula, for example before sending a file or deleting the source data. Here’s how.

One cell

  1. Select cell C7, which has a SUM function.

    Cell C7 with a SUM formula

  2. Press F2 to edit the cell.

    The cell in edit mode after pressing F2

  3. Press F9. The formula changes to its value.

    The formula replaced by its value after pressing F9

  4. Press Enter.

Now, when you select C7, there’s only a number, no formula.

A range of cells

  1. Select the formula cells, E4:E11.

    The formula cells E4:E11 selected

  2. Point at the edge of the selection until the pointer becomes a four-headed arrow. Hold down the right mouse button and drag the range a little to the right.

    Dragging the selection with the right mouse button

  3. Still holding the button, drag it back to where it was, and release.

  4. In the menu that appears, click Copy Here as Values Only.

    Choosing Copy Here as Values Only

Result: all the formulas are replaced with their values.

The range converted to values

Tip: Another way: copy the range (Ctrl + C), then paste it over itself as values. See Paste Options.