Paste values, not formulas

When copying the contents of a cell, you may need to paste only the value—not the underlying formula, which can be seen in the formula bar.

For example, you might need to copy only the result value of a formula into a cell on another worksheet. Or, you might want to delete the values that you used in a formula—after you copy the formula result value to another cell on the worksheet. If you were to perform a simple copy, such actions would cause an invalid cell reference error (#REF!) to appear in the destination cell, since the cells that contain the values that you used in the formula could no longer be referenced.

You can avoid this error by pasting only the resulting value of a formula into a destination cell.

Follow these steps:

  1. On a worksheet, select the cells that contain the resulting value of a formula that you want to copy.

  2. On the Home tab, in the Clipboard group, click Copy Button image or press CTRL+C on your keyboard.

    Excel Ribbon Image

  3. Select the upper-left cell of the paste area.

    Tip:  To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.

  4. On the Home tab, in the Clipboard group, click Paste Button image , and then click Paste Values. Or, press Ctrl+Alt+V to display the Paste Special dialog box.

  5. Select Values and click OK.

See Also

Copy cell data and paste attributes only

Expand your Office 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.

×