» Pasting Values in Excel 2007

To paste the calculated value of a formula into a single cell (thus overwriting the formula):

Select a cell containing a formula and press F2 to edit and then F9 to calculate.

To paste the calculated value of a formula into a single cell under the cell containing the formula:

Press Ctrl+Shift+".

To paste values in a range of cells, use the Paste Special dialog box:

Copy a range of cells containing formulas, select Home -> Paste arrow symbol (In Clipboard Group)
-> Paste Values.
Or
Right click, and select Paste Special -> Values.



To paste values using a shortcut menu:

1. Select a range of cells containing formulas.
2. With the mouse cursor over the selection border, drag the range while holding down the right button.
3. Release the mouse button and select Copy Here As Values Only from the shortcut menu.