ShortcutdrillExcel shortcuts / editing / Copy a row to below the data
Copy a row to below the data in Excel: Ctrl+Shift+Right, Ctrl+C, Ctrl+Down, Home, Down, Ctrl+V (Mac: Cmd+Shift+Right, Cmd+C, Cmd+Down, Fn+Left, Down, Cmd+V)
| Windows | Ctrl+Shift+Right, Ctrl+C, Ctrl+Down, Home, Down, Ctrl+V |
|---|---|
| Mac | Cmd+Shift+Right, Cmd+C, Cmd+Down, Fn+Left, Down, Cmd+V |
| Group | editing |
Drill: Copy the headers further down. Pro drill. Twenty-five drills are free.
What it does and when to use it
A chain of basic moves: select the header, copy it, jump to the bottom of the data, go to column A, step down and paste. Chains like this are what the drills build; none of the steps is hard, the speed comes from not thinking about them.
The common mistake
Pasting over the last data row instead of below it. Ctrl+Down lands on the last filled cell; press Down once more.
Related shortcuts
- Undo Ctrl+Z
- Fill down Ctrl+D
- Fill right Ctrl+R
- Clear the selection Delete
- Delete the row Shift+Space, Ctrl+-
- The printable cheat sheet
Questions
How do I paste without the mouse?
Move to the destination with the arrows or Ctrl+G, then Ctrl+V. The marquee around the copied cells stays until you press Esc.
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