Jan 11, 2006 #1 Lotus14 Technical User Joined Oct 7, 2005 Messages 6 Location US Does anyone know if there is a keyboard shortcut for the "Paste Special" command in Excel?
Jan 11, 2006 1 #2 xlbo MIS Joined Mar 26, 2002 Messages 15,080 Location GB not really but there is a keystroke sequence.... Alt + e > s or you could put the pastespecial>values / pastespecial>formats button on your toolbar.... Upvote 0 Downvote
not really but there is a keystroke sequence.... Alt + e > s or you could put the pastespecial>values / pastespecial>formats button on your toolbar....
Jan 11, 2006 1 #3 Zathras Programmer Joined Nov 12, 2002 Messages 3,317 Location US 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. Upvote 0 Downvote
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.
Jan 11, 2006 #4 xlbo MIS Joined Mar 26, 2002 Messages 15,080 Location GB Z - that is exactly what I do but thought I'd offer a non VBA way 1st....... Upvote 0 Downvote
Jan 11, 2006 #5 Zathras Programmer Joined Nov 12, 2002 Messages 3,317 Location US x - I use the tool bar button. Macro for that seems overkill. Upvote 0 Downvote
Jan 11, 2006 Thread starter #6 Lotus14 Technical User Joined Oct 7, 2005 Messages 6 Location US Thank you xlbo & Zathras. I added the action to my toolbar- looks good! Pam Upvote 0 Downvote
Jan 12, 2006 #7 xlbo MIS Joined Mar 26, 2002 Messages 15,080 Location GB 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.... Upvote 0 Downvote
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....
Jan 12, 2006 #8 dcompto Technical User Joined Jul 5, 2001 Messages 751 Location US See http://exceltips.vitalnews.com/Pages/T0674_Shortcut_for_Pasting_Only_Values.html Upvote 0 Downvote