Copy cell values, not formulas

Sometimes, when you copy the contents of a cell, you want to paste just the value and not the underlying formula that is displayed in the formula bar.

For example, you might want to copy the resulting value of a formula to a cell on another worksheet. Or you might want to delete the values that you used in a formula after you copied the resulting value to another cell on the worksheet. Both of these actions cause an invalid cell reference (#REF!) error to appear in the destination cell, because the cells that contain the values that you used in the formula can no longer be referenced.

You can avoid this error by pasting the resulting values of formulas without the formula in destination cells.

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

  2. On the Home tab, in the Clipboard group, click Copy Button image.

    Excel Ribbon Image

    Keyboard shortcut  You can also press CTRL+C.

  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 the arrow under Paste Button image, and then under Paste Values, click the option that you want.

    Tip   As you move the pointer over the options on the menu, the results will appear as a preview in the paste area on your worksheet.

Applies To: Excel 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language