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.
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.