paste special hotkey

V

Vik

IS there a way to do past special-values using the keyboard (similar t
Cntrl-V) does paste all. Is there a way to make a hotkey for this?
Pls help. write to me directly at [email protected]
Thx
Vi
 
C

Charles Maxson

Vik,

You can create a macro and assign it a shortcut key to it. The macro could
look like this:

Sub PasteSpecial()
ActiveCell.PasteSpecial Paste:=xlPasteValues
End Sub

Then look under Tools | Macros | Macros... > Options... button to assign a
shortcut key to the macro.
 
D

Dave Peterson

Along with the macro approach:

You could use the built in accelerator keys:

Alt-E,S,V (and hit enter)

Or you could drag the Paste Values icon onto your favorite toolbar (but that
would be a mouse click).

It's under Tools|Customize|Commands tab|Edit Category.

It's icon is a clipboard with 12 in it.

If you use the macro option, you'll destroy the Undo stack. If you use the
icon/shortcut keys, you won't.

===
And one more way. If you use the mouse and rightclick drag, you'll see an
option to "copy here as values only".
 
Top