Alt + E + S + T is a legacy pre-ribbon shortcut for Paste Transpose. With Accelerator Keys, this shortcut works exactly like the modern Alt + H + V + T sequence.
If you are looking for the Alt + E S T shortcut on Mac Excel, you may be familiar with this shortcut from older versions of Excel (2003 and earlier). This legacy shortcut still works with Accelerator Keys and maps to the modern ribbon equivalent.
Alt + E + S + T is the legacy shortcut for Edit > Paste Special > Transpose. It pastes your copied data with rows and columns swapped - rows become columns and columns become rows.
| Shortcut | Era | Menu Path |
|---|---|---|
| Alt + E + S + T | Legacy (Excel 2003) | Edit > Paste Special > Transpose |
| Alt + H + V + T | Modern (Ribbon) | Home > Paste > Transpose |
Both shortcuts work with Accelerator Keys!
Note: This legacy shortcut is automatically mapped to the modern ribbon equivalent (Alt + H + V + T), so you can use whichever you prefer.
Looking for a paste transpose shortcut on Mac? The legacy Alt + E S T shortcut works with Accelerator Keys, giving you the fastest way to transpose in Excel on Mac. No need to navigate menus β just press Option β E β S β T (or Option β H β V β T for the modern equivalent).
Without Accelerator Keys, pasting with transpose on Mac Excel requires:
The paste transpose Excel shortcut (Alt + E S T) does all of this in a single key sequence.
Transpose is useful when you need to:
The modern ribbon shortcut is Alt + H + V + T (Home > Paste > Transpose). Both work with Accelerator Keys.
No, the native Mac Excel βKeyTipsβ does not support legacy pre-ribbon shortcuts. You need Accelerator Keys to use Alt + E + S + T on Mac.
Yes, Transpose works with both values and formulas. Cell references will be adjusted accordingly when transposed.