paste special hotkey

  • Thread starter Thread starter Vik
  • Start date Start date
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 (e-mail address removed)
Thx
Vi
 
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.
 
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".
 
u can go to www.asap-utilities.com to get the asap software, it is ver
good:)
then u can press ctrl+shift+Y to get the past special function, but i
u drag the icon of "past value" "past formula", it will be easier

joanliuwe
 
woops, sorry for my poor english....

can anyone tell me how to find a free hotkey software? mine is a tria
version:(

thanks a lot!

joa

joanliuwe
 
Back
Top