Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

# Delete or remove a formula

When you delete a formula, the result of the formula is also deleted. If you don’t want to delete the value, you can instead remove the formula only.

What do you want to do?

## Delete a formula and its result

- Select the cell or range of cells that contains the formula.

If the formula is an array formula, you must first select all cells in the range of cells that contains the array formula:

- Click a cell in the array formula.
- On the Home tab, in the
**Editing**group, click**Find & Select**, and then click**Go To**. - Click
**Special**. - Click
**Current array**.

- Press DELETE.

## Remove a formula and leave the result in place

To do this, you copy the formula and then paste in the same cell by using the Paste Values option.

- Select the cell or range of cells that contains the formula.

If the formula is an array formula, you must first select all cells in the range of cells that contains the array formula:

- Click a cell in the array formula.
- On the
**Home**tab, in the**Editing**group, click**Find & Select**, and then click**Go To**. - Click
**Special**. - Click
**Current array**.

- On the
**Home**tab, in the**Clipboard**group, click**Copy**.

**Keyboard shortcut** You can also press CTRL+C.

- On the
**Home**tab, in the**Clipboard**group, click the arrow below**Paste**, and then click**Paste Values**.

Applies to:

Excel 2010, Excel 2007