1
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 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.
2
Ctrl + RFill right from the leftmost cell
The content of the leftmost selected cell is copied into all cells to the right.
3
Ctrl + `Verify formula continuity
After filling formulas horizontally, toggle formula view to check for reference drift.
4
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.
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 alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →