Delete a formula

There are two ways to delete a formula:

  • If you no longer need the formula or its resulting value displayed on the worksheet, you can delete the formula along with the formula result.

  • If you want to keep the resulting value displayed but no longer want to show the formula, you can delete the formula without removing its result.

What do you want to do?

Delete a formula along with its resulting value

Delete a formula without removing its resulting value

Delete a formula along with its resulting value

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

  2. Press Delete.

Top of Page

Delete a formula without removing its resulting value

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

If the formula is an array formula, select the range of cells that contains the array formula.

How to select a 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.

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

    Excel Ribbon Image

    Keyboard shortcut    You can also press Ctrl+C.

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

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×