Learn › Excel › Fill right

Excel fill right shortcut: Ctrl + R

Copy the first cell into all the selected cells to its right.

← All Excel shortcuts

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.

WindowsCtrl+R
Mac⌘+R

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.

English (US)Ctrl+R
HrvatskiCtrl+R
DeutschStrg+R
EspañolCtrl+R
FrançaisCtrl+R
PortuguêsCtrl+R
ItalianoCtrl+R
TürkçeCtrl+R
Bahasa IndonesiaCtrl+R
PolskiCtrl+R

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

  1. Type a value, or a formula, in the first cell of the row.
  2. Select that cell and the empty cells to its right (Shift + Right arrow).
  3. Press Ctrl + R (on a Mac: Command + R). Press Ctrl + D to fill down instead.
Good to know: The filled cell must be the leftmost cell of the selection. Ctrl + R overwrites anything that is already in the selected cells, and it only copies the first cell, it does not make a series like Jan, Feb, Mar.

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:

Fill downCtrl+D

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.

← All Excel shortcuts

Chrome extensions

Free web tools

Free games