Ctrl+RFill RightHorizontal Table

Copy the Left Cell Rightward Instantly with Ctrl+R

Horizontal fill gets less attention than vertical fill, but it comes up often in real work. Ctrl+R makes it just as fast.

Shortcuts you will master in this article

Ctrl + R / Ctrl + Shift + → / Ctrl + `

Dragging Formulas Rightward Across Columns Is Inefficient

Sales comparisons, monthly budgets, evaluation matrices — any table that expands rightward benefits from Ctrl+R over dragging the fill handle.

Ctrl+D (fill down) gets all the attention, but Ctrl+R is its horizontal counterpart and equally useful once you know it.

How to Use Ctrl+R

Select the leftmost source cell plus all cells to the right you want to fill, then apply.

Ctrl + Shift + →Select the target range going right

Start from the source cell and extend the selection rightward to where you want to fill.

Ctrl + RFill right from the leftmost cell

The content of the leftmost selected cell is copied into all cells to the right.

Ctrl + `Verify formula continuity

After filling formulas horizontally, toggle formula view to check for reference drift.

Ctrl + ZUndo if the fill went too far

Selecting a range that's too wide is easily fixed with a quick undo.

Excel Shortcut Practice

Master Excel shortcuts and
gain real productivity skills

Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.

Start shortcut practice →View all shortcuts

When Ctrl+R Is the Right Tool

Best for tables that expand by column: monthly data, department comparisons, scoring matrices.

Works for formatting as well as formulas — use it to copy cell styles rightward too.

If the table has many merged cells, clean up the layout before filling to avoid unexpected behavior.

Related Shortcuts

Visit each shortcut detail page to see key positions and usage tips.

Key	Action
`Ctrl + R`	Fill Right
`Ctrl + Shift + Up`	Select to Edge of Data
Ctrl + `	Toggle Formula View
`Ctrl + Z`	Undo

Frequently Asked Questions

Q. What's the difference between Ctrl+D and Ctrl+R?

A. Ctrl+D fills downward; Ctrl+R fills rightward. Think of them as a matched pair.

Q. What's the main thing to watch out for when filling formulas to the right?

A. Absolute vs. relative references. Use F4 to toggle reference locking as needed.

Q. What happens if I don't include the source cell in my selection?

A. The reference shifts and you won't get the intended result. Always start your selection from the cell you want to copy.

Q. How do I memorize Excel shortcuts faster?

A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and switch between difficulty, category, and review practice for faster retention.