Excel Converting Formulas to Values

Sometimes, you may want to convert a formula to its current value (remove the formula and leave only its result). For example, want may want to prevent future changes to the value of a cell if other cells that the formula references change.

To convert a formula to its current value, follow these steps:

1. Select the cell that contains the formula. To convert several formulas, you can select a range.
2. Click the Copy button on the Ribbon's Home tab. (You can also press Ctrl+C or right-click the cell and choose Copy from the contextual menu.)
3. Click the bottom part of the Paste button on the Ribbon's Home tab (the part with the downward pointing arrow) and choose Paste Values from the menu.
4. Press Enter or Esc to cancel Copy mode.

The preceding procedure overwrites the formulas. To put the current values of the formulas in a different (empty) area of the worksheet, select a different cell or range before Step 3.