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:
On a worksheet, select the cells that contain the resulting value of a formula that you want to copy.
On the Home tab, in the Clipboard group, click Copy or press CTRL+C on your keyboard.
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.
On the Home tab, in the Clipboard group, click Paste , and then click Paste Values. Or, press Ctrl+Alt+V to display the Paste Special dialog box.
Select Values and click OK.