Results 1 to 6 of 6

Shortcut key for 'Transpose'

This is a discussion on Shortcut key for 'Transpose' within the Excel Questions forums, part of the Question Forums category; Hello Excel Wizards. My co-worker wants to know what the shortcut key is for the command Transpose and/or 'Paste Special' ...

  1. #1
    Board Regular
    Join Date
    May 2002
    Posts
    52

    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

    Default

    anyone?

  3. #3
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530

    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

    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
    2,378

    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

    Default

    Thanks to all for the help.

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