Creating a Shortcut for Pasting Values

 Creating a Shortcut for Pasting Values

Alt+F8 (brings up the macro window)

Code for Macro

Sub PasteVal()
    Selection.PasteSpecial Paste:=xlValues
End Sub

Once macro created and saved, press Alt-F8 again and assign short cut key for ease of use.

Reference: http://excel.tips.net/T002657_Creating_a_Shortcut_for_Pasting_Values.html