Faster paste values shortcut than alt+ESV

**submariner18** · 06-29-2015, 10:44 AM

For some reason half the time the alt+ESV doesn't register for me, maybe my computer is slow. Plus it's 4 separate keystrokes--hardly a "short"cut. I'm looking for a faster way to paste values only, as I do this all the time.

I tried adding paste to the quick access bar but it still requires picking out values only specifically. I tried using a macro:

Sub PasteSpecial_Values()
On Error Resume Next
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
On Error GoTo 0
End Sub

However this macro wipes the undo feature, meaning if I accidentally paste the wrong thing, I cannot undo the damage. I'd like to retain the undo ability.

Anyone with a better idea?

**MrShorty** · 06-29-2015, 11:02 AM

I tried adding paste to the quick access bar but it still requires picking out values only specifically.

A quick check of the available "paste" commands that can be added to the quick access bar (at least in Excel 2007), there are about 10 possible "paste" options to add (including a "paste values" command). Which of these did you add to the quick access toolbar? Did you use the basic "paste" command that shows up in the "popular" category? Or did you navigate to the "all commands" or "home group" commands category and use one of the other "paste" commands? My first thought is that you simply need to dig deeper into the available commands that can be added to the quick access toolbar until you find the "paste values" command.