ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shortcut key for "Paste Options" and "Error Checking" buttons? (https://www.excelbanter.com/excel-discussion-misc-queries/112903-shortcut-key-paste-options-error-checking-buttons.html)

johndog

Shortcut key for "Paste Options" and "Error Checking" buttons?
 

When you copy and paste, a little 'Paste Options' button will usually appear
below the pasted data. I very frequently want to modify the paste options
(in fact in some cases I'm unhappy with the default behavior), but I'd rather
not use the mouse. Is there a keyboard shortcut to 'click' this button and
raise the menu?

Thanks,
John

skatonni via OfficeKB.com

Shortcut key for "Paste Options" and "Error Checking" buttons?
 
Here is a list of Excel shortcuts.
http://office.microsoft.com/en-ca/as...116591033.aspx

You can get the Paste Special dialog with
Alt + E then S

johndog wrote:
When you copy and paste, a little 'Paste Options' button will usually appear
below the pasted data. I very frequently want to modify the paste options
(in fact in some cases I'm unhappy with the default behavior), but I'd rather
not use the mouse. Is there a keyboard shortcut to 'click' this button and
raise the menu?

Thanks,
John


--
Message posted via http://www.officekb.com



All times are GMT +1. The time now is 12:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com