Keyboard Shortcut for "Paste Special" 2

[Lotus14]

Does anyone know if there is a keyboard shortcut for the "Paste Special" command in Excel?

 

[xlbo]

not really but there is a keystroke sequence....

Alt + e > s

or you could put the pastespecial>values / pastespecial>formats button on your toolbar....

 

[Zathras]

Not that I know of, but you can add a button to the tool bar for "paste special values" to reduce that action to a single click.

If you really need/want a keyboard shortcut, you could write a macro and assign a key to it.

 

[xlbo]

Z - that is exactly what I do but thought I'd offer a non VBA way 1st.......

 

[Zathras]

x - I use the tool bar button. Macro for that seems overkill.

 

[Lotus14]

Thank you xlbo & Zathras. I added the action to my toolbar- looks good!

Pam

 

[xlbo]

aaaah - I have the button as well but have the macro assigned to Ctrl+Z (I use the button for undo), so I can do

Ctrl + C (copy)
then
Ctrl + Z (Paste Special - values)
or
Ctrl + V (Paste)

I guess it depends on how often you use the paste special>values option....

 

[dcompto]

See

http://exceltips.vitalnews.com/Pages/T0674_Shortcut_for_Pasting_Only_Values.html