Paste transposed in Excel

Paste transposed in Excel: Ctrl+C, Ctrl+Alt+V, E, Enter (Mac: Cmd+C, Cmd+Ctrl+V, E, Enter)

Windows	`Ctrl+C, Ctrl+Alt+V, E, Enter`
Mac	`Cmd+C, Cmd+Ctrl+V, E, Enter`
Group	paste special

Practice this shortcut

Drill: Paste transposed. Pro drill. Twenty-five drills are free.

What it does and when to use it

Transpose turns a copied row into a column or a column into a row on paste. Assumptions laid out across a row become a tidy input column in three presses.

The common mistake

Transposing formulas with relative references, which then point at the wrong cells. Paste values and transpose, or fix the references.

Related shortcuts

Paste values only Ctrl+C, Ctrl+Alt+V, V, Enter
Paste formats only Ctrl+C, Ctrl+Alt+V, T, Enter
The printable cheat sheet

Questions

Can I transpose with a formula instead?

Yes, =TRANSPOSE(range) returns a live transposed copy. Paste Special gives a static one.

Learn it by pressing it

Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.

Start the drill