Shortcutdrill

Level 7: Alt ribbon sequences Drill 54 of 80 Pro

Paste transposed

An Excel shortcut drill from Shortcutdrill. Solve it with a live sheet in your browser with a limit on key presses, and it is checked the moment you submit.

The task

The header row A1:E1 is selected. Turn it into a column starting at G2.

What this drill teaches

Transpose flips rows into columns on paste. Use Go To (Ctrl+G) to land on G2 without arrowing.

A hint if you get stuck

Windows: Ctrl+C, Ctrl+Alt+V, E, Enter. Mac: Cmd+C, Cmd+Ctrl+V, E, Enter. The drill allows 3 key presses.

This drill is part of Pro

Pro unlocks all 80 drills, with worked solutions and progress saved to your account. The free drills work without an account.

14-day refund, no questions. Cancel a subscription in one click. Students: 50% off annual with a .edu or .ac email.

Start with the free drills

More drills in Alt ribbon sequences