Delete a formula

It is pretty straight forward to delete both the formula and its result—select the cell or cells that contain the formula and press Delete. But below shows the steps for deleting the formula and keeping its 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

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

Paste command showing Paste Values

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!

×