Fill Right Shortcut (Ctrl+R / ⌘R)
Copy the leftmost cell across a selection: Ctrl+R on Windows, ⌘R on Mac. Shown with fill down and friends.
| Action | Mac | Windows | |
|---|---|---|---|
| Fill right | ⌘R | Ctrl+R | |
| Fill down | ⌘D | Ctrl+D | |
| Copy | ⌘C | Ctrl+C | |
| Paste | ⌘V | Ctrl+V | |
| Repeat last action | ⌘Y | Ctrl+Y or F4 | |
| Select to right edge of data | ⌘⇧→ | Ctrl+Shift+→ |
Fill a value or formula across
Select a range starting at the cell you want to copy, then press Ctrl+R (Windows) or ⌘R (Mac). Excel fills the leftmost cell's content — including relative formula references — into every cell to its right.
Fill right vs fill down
Fill right has a vertical twin: Ctrl+D / ⌘D fills the top cell downward. Both respect relative and absolute references, so a formula like =A1*$B$1 adjusts the A1 part but keeps $B$1 fixed.
FAQ
What is the fill right shortcut in Excel?
Press Ctrl+R on Windows or ⌘R on Mac to fill the leftmost cell of a selected range into the cells to its right.
What is the difference between Ctrl+R and Ctrl+D?
Ctrl+R fills to the right from the leftmost cell; Ctrl+D fills downward from the top cell. On Mac they are ⌘R and ⌘D.
Does fill right copy formulas?
Yes — it copies formulas and adjusts relative references automatically, while keeping absolute ($) references fixed.