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

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×