The transpose shortcut in Excel is a paste special step: copy the cells with Ctrl + C, click where the result should start, press Ctrl + Alt + V, then E to tick Transpose, and Enter. A row becomes a column, or a column becomes a row.
The ribbon sequence Alt, H, V, T does the same in one go. If you want the flipped copy to update when the original changes, use the TRANSPOSE formula instead.
Quick facts
Copy first
Ctrl + CPaste transposed
Ctrl + Alt + V, E, EnterRibbon
Alt, then H, then V, then TFormula
=TRANSPOSE(range)Undo
Ctrl + ZMac
Paste Special, Transpose
Transpose shortcut in Excel, step by step
- Select the range to flip, for example months listed across row 1.
- Press Ctrl + C.
- Click an empty cell where the transposed data should begin, away from the original.
- Open Paste Special with Ctrl + Alt + V, tick Transpose with E, and confirm.
The original stays where it was. Delete it afterwards if you only needed the new layout.
Transpose methods compared
| Method | Keys | Updates with source? |
|---|---|---|
| Paste Special | Ctrl + Alt + V, E, Enter | No, a fixed copy |
| Ribbon paste | Alt, then H, then V, then T | No |
| TRANSPOSE formula | =TRANSPOSE(A1:D10) | Yes |
More paste options are on the paste special in Excel page.
The TRANSPOSE formula
In current Excel, click one empty cell and type =TRANSPOSE(A1:D10), then press Enter. The result spills into as many cells as needed and changes when the source changes. In older versions, select the exact target size first and confirm with Ctrl + Shift + Enter. You cannot edit single cells of the result; change the source instead.
Common reasons to transpose
Data from other systems often arrives sideways: months across the top when you need them down a column for a chart or pivot, or one record per column instead of per row. Survey results and attendance exports are common examples. Transposing fixes the layout without retyping. It is also useful when pasting a list from a web table that was the wrong way round.
When transpose does not work
| Problem | Fix |
|---|---|
| Cannot paste, overlapping area | Paste somewhere that does not overlap the copied range |
| Transpose option missing | You copied from outside Excel; paste normally first, then copy again |
| #SPILL error with the formula | Cells in the way have data; clear them |
| Formulas point to wrong cells | Relative references shift; paste values or use absolute references |
Transpose with formatting and formulas
Transposing copies number formats, colours and borders along with values. Formulas are transposed too, but their cell references shift, which can produce wrong results; check a few cells afterwards. For clean numbers, tick both Values (V) and Transpose (E) in the Paste Special box. Large blocks transpose instantly, but the target area must be free, or Excel refuses rather than overwrite data.
Frequently asked questions
What is the transpose shortcut in Excel?
Copy, then Ctrl + Alt + V, E, Enter.
How do I convert a row to a column in Excel?
Copy the row and paste with Transpose ticked.
What are the ribbon keys for transpose?
How do I keep the transposed data linked?
Use the TRANSPOSE formula.
Why can I not paste transposed data?
The target overlaps the copied range. Choose another place.
How do I transpose in Excel for Mac?
Edit, Paste Special, then tick Transpose.