Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

Delete a formula

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

  2. Press Delete.

Delete a formula but keep the results

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.

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

Delete an array formula

To delete an array formula, make sure you select all cells in the range of cells that contains the array formula. To do that:

  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.

  5. Press DELETE.

Delete a formula but keep the results

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

  2. Click Home > Copy (or press Ctrl + C).

    Copy command in the Clipboard group

  3. Click Home > arrow below Paste > Paste Values.

    Paste command showing Paste Values

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×