1
Ctrl + CCopy the source range
Copy the range you want to rotate — rows become columns and vice versa.
TransposePasteRow Column Swap
How to Transpose Rows and Columns When Pasting in Excel
If you're manually rearranging rows and columns every time you need to change a table's orientation, Transpose Paste is exactly what you're missing.
Shortcuts you will master in this article
Ctrl + C / Ctrl + Alt + V / Enter
Manual Row-Column Rearrangement Is Slow and Error-Prone
Rotating a vertical table to horizontal — turning row headers into column headers, converting month-by-row into month-by-column — done by hand, this is a recipe for missed cells and sequence errors.
Transpose Paste flips the orientation while preserving the original data's order.
How to Transpose Paste
Make sure the destination area has enough empty space before you start.
2
Ctrl + Alt + VOpen Paste Special
Transpose is available inside the Paste Special dialog.
3
E → EnterPaste with rows and columns swapped
Select the Transpose option in the dialog. Headers and data positions are all rotated in one step.
4
Ctrl + ZUndo if the layout isn't right
If the destination area was too small, the layout may be disrupted — verify the result and undo if needed.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Good Uses for Transpose Paste
Converting a vertical data list into a horizontal summary report.
Reformatting month-by-row comparisons into column-oriented layouts for presentations.
If the source contains formulas, always verify how references behave after transposing.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + C | Copy |
Ctrl + Alt + V | Paste Special |
Ctrl + Z | Undo |
Frequently Asked Questions
Q. Does Transpose Paste delete the original data?
A. No. It creates a transposed copy at the destination — the source remains untouched.
Q. Can I transpose values only?
A. Yes. Combining Transpose with Values-only paste is a common pattern when you don't want to carry references into the new layout.
Q. Can I transpose any table?
A. Generally yes, but tables with merged cells or complex formatting may produce unexpected results — always verify.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →