Normally when you copy the contents of a cell, the value and the formula is copied. However, there may be times when you only want to copy the value, NOT the formula. In such cases, you can use the Paste Values option as I have described below.
- Within your Excel file, select the cell that contains the resulting value of a formula that you want to copy.
- From the Home tab, within the Clipboard group, click Copy. You can also right click the cell and select Copy.
- Select the upper-left cell where you want to paste the value.
- From the Home tab, within the Clipboard group, click Paste, and then click Paste Values.