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 (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.).
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.
- On a worksheet, select the cells that contain the resulting values of a formula that you want to copy.
- On the Home tab, in the Clipboard group, click Copy .
Keyboard shortcut You can also press CTRL+C.
- Select the upper-left cell of the paste area (paste area: The target destination for data that's been cut or copied by using the Office Clipboard.).
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 the arrow under Paste , 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.