Wednesday, January 18, 2017

Delete a formula

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

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)