MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Shortcut key for Paste Values


Posted by Alan on January 01, 2002 1:28 PM

Is there an easy way to assign a shortcut key (such as Alt+Ctrl+V) to the Paste Values command? I've already added a button to my toolbar.


Posted by Joel Horowitz on January 01, 2002 1:32 PM

Well, what I usually do is ALT-e-s-v followed by ENTER. It looks a little primitive, but once you're used it works fine.

Posted by Alan Levin on January 01, 2002 1:40 PM

Posted by Alan Levin on January 01, 2002 1:42 PM

Thanks-- Of course that works, since it navigates the menus using the keyboard. Is there a way to assign an actual keyboard shortcut, though?

Posted by Jacob on January 01, 2002 1:52 PM

Hi

Make a macro and put it in your personal.xls workbook.

Private sub PasteIt()

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False


End Sub

Then assign a hot key to trigger it.


Jacob

Posted by Alan Levin on January 01, 2002 2:37 PM

Jacob-- You're absolutely right-- thank you.

Alan

Posted by Joel Horowitz on January 02, 2002 7:25 AM

Danger of using a macro

The danger of that is that there is no possibility for undoing this action, which can be very annoying when you paste values where you copied them (= you may look formulas). Am I wrong?

Joel