The Ctrl + R guide
Write the formula once, select it together with the empty cells to its right, and press Ctrl+R (⌘+R on a Mac). Each copy's references move one column per cell: SUM(B2:B5) becomes SUM(C2:C5).
How it works
Fill Right copies the leftmost cell of the selection into every other cell of it, as a paste would: values, formula and format. A reference without $ moves with each copy, so one total per month comes from a single formula. It's fill down turned on its side.
Step by step
- Write the formula in the first cell,
=SUM(B2:B5)in B6. - Select from that cell to the last one that needs it, B6:G6.
- Press Ctrl+R. Click G6: it says
=SUM(G2:G5).
Dragging the fill handle, the small square at the corner of the selection, does the same with the mouse.
Common mistakes
- Ctrl+D instead of Ctrl+R. Fill Down copies the cell above, so the total row fills up with numbers from the row over it.
- Only the empty cells selected. The formula's cell has to be the leftmost one in the selection; otherwise Excel copies whatever is to the left of it.
- A $ on the column.
$B2:$B5stays on column B in every copy, so every month shows January's total.
In a browser, Ctrl+R normally reloads the page. On this practice sheet it fills right, as it does in Excel.
FAQ
- What is the shortcut for Fill Right in Excel?
- Ctrl+R on Windows. On a Mac, Microsoft lists Command+R or Control+R. Select the cell to copy and the cells to its right first.
- What is the difference between Ctrl+D and Ctrl+R?
- Ctrl+D (Fill Down) copies the top cell of the selection down; Ctrl+R (Fill Right) copies the leftmost cell across to the right.
- Why does Fill Right copy the same total into every cell?
- The formula has $ in front of the column, like $B2:$B5, which locks it. Remove the $ so each copy moves to its own column.



































































