Excel fill right shortcut: Ctrl + R
Copy the first cell into all the selected cells to its right.
With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.
Keys on keyboards of other languages
The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.
What it does
Ctrl + R copies the content and format of the leftmost cell of your selection into all the other selected cells to its right. It copies formulas too and adjusts the cell references, just like dragging the fill handle sideways.
When to use it
Use it to repeat a value, a status or a formula across a row, for example the same budget for every month. Select the filled cell and the empty ones beside it, press Ctrl + R, and you are done.
How to do it
- Type a value, or a formula, in the first cell of the row.
- Select that cell and the empty cells to its right (Shift + Right arrow).
- Press Ctrl + R (on a Mac: Command + R). Press Ctrl + D to fill down instead.
A quick example
In the plan table, type 25 in B2, select B2 to E2 with Shift + Right arrow, and press Ctrl + R. All four cells show 25. With a formula in the first cell, each column gets its own version of the formula.
Ctrl + R, Ctrl + D and the fill handle
Ctrl + R fills right and Ctrl + D fills down. The fill handle, the small square in the corner of the cell, does the same by dragging, and it can also continue a series such as Mon, Tue, Wed. Ctrl + R only copies the first cell.
Shortcuts mentioned on this page, with video:
Not working? Check this
- Nothing happens, or the page reloads: click into the sheet first, not into the formula bar, and then press the keys.
- Cells beside it were overwritten: Ctrl + R replaces what is in the selected cells. Press Ctrl + Z and select only empty cells.
- You wanted Jan, Feb, Mar and got the same word everywhere: use the fill handle, or Fill, Series, for a series.
- On a Mac use Command + R.
Quick answers
What is the shortcut to fill right in Excel?
Select the first cell and the cells to its right, then press Ctrl + R. On a Mac use Command + R.
How do I fill down instead?
Select the cell and the cells below it, then press Ctrl + D.
Does Ctrl + R copy formulas?
Yes. It copies the formula and adjusts the references for each column, as if you had dragged the fill handle to the right.

