ShortcutdrillExcel shortcuts / editing / Fill right
Fill right in Excel: Ctrl+R (Mac: Cmd+R)
| Windows | Ctrl+R |
|---|---|
| Mac | Cmd+R |
| Group | editing |
Drill: Copy a total across. Pro drill. Twenty-five drills are free.
What it does and when to use it
Select the formula cell and the cells to its right, then Ctrl+R copies it across. It is how a five-year schedule gets built from one year of formulas.
The common mistake
Forgetting to lock the column of an input before filling right, so year two reads from the wrong cell. Press F4 on the reference first.
Related shortcuts
- Undo Ctrl+Z
- Fill down Ctrl+D
- Clear the selection Delete
- Delete the row Shift+Space, Ctrl+-
- Insert a row Shift+Space, Ctrl+Shift+=
- The printable cheat sheet
Questions
Why did my fill right break the formula?
A reference moved that should have stayed. Lock its column with F4 until it reads $B3, then fill again.
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