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

Remove a formula and leave the result in place

Delete a formula and its result

  1. 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:

    1. Click a cell in the array formula.

    2. On the Home tab, in the Editing group, click Find & Select, and then click Go To.

    3. Click Special.

    4. Click Current array.

  2. Press DELETE.

Top of Page

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.

  1. 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:

    1. Click a cell in the array formula.

    2. On the Home tab, in the Editing group, click Find & Select, and then click Go To.

    3. Click Special.

    4. Click Current array.

  2. On the Home tab, in the Clipboard group, click Copy Button image.

    Keyboard shortcut  You can also press CTRL+C.

  3. On the Home tab, in the Clipboard group, click the arrow below Paste Button image, and then click Paste Values.

Top of Page

Applies To: Excel 2007, Excel 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language