General discussion


Excel Keyboard Command for Paste Options

By ddb64 ·
Is there a keyboard command which will open the Paste Options icon which appears when one pastes in Excel? I copy/paste tons of data from one workbook to another regularly, moving around using only keyboard commands, and find it very rough to continually have to reach for my mouse to click on the icon, and then choose "match destination formatting". The "M" is underlined so it suggests availability by pressing Alt-m, but that doesn't work either before or after the icon is clicked. HELP! Thanks in advance,

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by rkuhn In reply to Excel Keyboard Command fo ...

Sounds like a perfect opportunity to use a macro assuming that you are copying and pasting from the same cell ranges over and over.

For example:

Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

It could be done with differing cell ranges but the above is a simplified example.

Collapse -

There is a shortcut

by jonathanparkeremail In reply to

ALT+SHIFT+F10 is the shortcut you need in Excel 2003 and Word 2003

Collapse -


by ilia.imerlishvili In reply to There is a shortcut

"ALT+SHIFT+F10" is exactly what I was looking for for a long time. Very useful post. Thanks.

Collapse -

by ddb64 In reply to Excel Keyboard Command fo ...

Thanks Rick. I will try it, but want to clarify I'm talking about Paste OPTIONS, not Paste Special, which IS available via a toolbar, and therefore via keyboard commands. Paste Options pops up if you have it checked in Tools/Options/Edit. I am not aware of a toolbar location for Past Options, so if there is one, please educate me! Also, I am not copying the same ranges each time.

Collapse -

try alt-shift-F10

by Jeong-hoon In reply to Excel Keyboard Command fo ...

try alt-shift-F10

Collapse -

alt menu (between the Winkey and Ctrl on the right) also works in Excel

by astidkalis In reply to Excel Keyboard Command fo ...

alt + menu key (between the Windows key and Ctrl on the right) also works in Excel.

Related Discussions

Related Forums