Software

Ask something
Discussion Locked

Excel Keyboard Command for Paste Options

0 helpful
6 replies

by ddb64

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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,

6 replies

by rkuhn040172

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.Copy
Range("B8").Select
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.

by ddb64

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.

This discussion is closed to new replies.