General discussion

  • Creator
    Topic
  • #2258712

    Excel Keyboard Command for Paste Options

    Locked

    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,

All Comments

  • Author
    Replies
    • #3214374

      Reply To: Excel Keyboard Command for Paste Options

      by rkuhn040172 ·

      In reply to Excel Keyboard Command for Paste Options

      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.

    • #3214346

      Reply To: Excel Keyboard Command for Paste Options

      by ddb64 ·

      In reply to Excel Keyboard Command for Paste Options

      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.

    • #2963035

      try alt-shift-F10

      by jeong-hoon ·

      In reply to Excel Keyboard Command for Paste Options

      try alt-shift-F10

    • #3033621

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

      by astidkalis ·

      In reply to Excel Keyboard Command for Paste Options

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

Viewing 3 reply threads