Shortcut key for 'Transpose'

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Shortcut key for 'Transpose'

  1. #1
    Board Regular
    Join Date
    May 2002
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hello Excel Wizards.
    My co-worker wants to know what the shortcut key is for the command Transpose and/or 'Paste Special'

    I was also wondering how one programs different commands for shortcut keys.

    Thanks a lot,
    Roj

  2. #2
    Board Regular
    Join Date
    May 2002
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    anyone?

  3. #3
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I don't believe that there are any built-in shortcut keys for these commands. The best you're going to get is a key-combo for Transpose:

    1. ALT + e
    2. s
    3. ALT + e
    4.

    I think this will also invoke the "Special Combo Death Move Finish" as well.

    HTH

  4. #4
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not really a shortcut key, but I find it works as fast:

    ALT + e + s (for "Paste Special" dialog box)

    ALT + e + s + e then hit return (for transpose)
    - old, slow, and confused
    ... but at least I'm inconsistent -

    (retired Excel 2003 user, 3.28.2008)

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,304
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-08-26 14:23, shades wrote:
    Not really a shortcut key, but I find it works as fast:

    ALT + e + s (for "Paste Special" dialog box)

    ALT + e + s + e then hit return (for transpose)
    consider creating your own shortcut key

    create a macro that does what you want
    (try macro recorder)

    and then assign a shortcut key combination to the macro.

    One macro that I use follows
    Sub PasteValue()
    '
    ' PasteValue Macro
    ' Copy selection and Paste as Value Ctrl-Shift-v
    '
    ' Keyboard Shortcut: Ctrl+Shift+V
    '
    With Selection
    .Copy
    .PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=False
    End With
    Application.CutCopyMode = False
    End Sub



    HTH Dave

    [ This Message was edited by: Dave Patton on 2002-08-26 15:21 ]

  6. #6
    Board Regular
    Join Date
    May 2002
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks to all for the help.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com