Pasting Values

 

Using keyboard shortcuts

To paste the calculated value of a formula into a single cell (thus overwriting the formula):
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 the calculated values from formulas in a range of cells, create and add a keyboard shortcut using the VBE:
Insert the code lines below into a regular Module in the Personal Macro Workbook:

Sub PasteValues ()
‘ Keyboard Shortcut: Ctrl+Shift+V

Selection.Formula=Selection.Value

End Sub

To paste values in a range of cells, use the Paste Special dialog box:
1. Copy a range of cells containing formulas, press Shift+F10 or right click, and then select Paste Special from the shortcut menu.
2. Select Values and click OK.

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

New in Excel 2002 and Excel 2003
The Paste icon has been expanded, enabling some options from the Paste Special dialog box to be quickly accessed.
Screenshot // Pasting Values
Pasting ValuesPasting Values



One thought on “Pasting Values

  1. “Highlight the cell containing the formula.
    Copy the cell.
    Without moving, PASTE SPECIAL / VALUES.

    You can do this for an entire worksheet, by selecting the entire worksheet instead of one cell.”

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>