Microsoft Excel Hints and Tips

Question
Is there a keyboard shortcut for Paste Special Values ?

Solution
There are three methods that you could use:

1) After pressing Ctrl + C to Copy - Press Alt + E and then S, then V, and then press Enter.

2) Enter the following code into VBA:

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

You can then assign a shortcut to the macro - Select Tools > Macro > Macros... > then highlight the PasteValues macro > Options > and then set your shortcut key.

3) Another way is to use the Paste Values toolbar button - Select View > Toolbars > Customize... > select the Commands tab and then in the list of Categories select Edit and then from the list of Commands find Paste Values and then drag it to your toolbar.

Whenever you want to paste values, you can click on your new toolbar button.

Back to Questions Index

Return to Excel Exchange homepage.