Shortcut key for Excel 'Transpose'

Post date: 20-Jul-2010 10:09:15

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 ]