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

Users are saying about us...

  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>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube