The Fill Down shortcut, Ctrl+D, copies a formula into adjacent cells below, replacing mouse dragging with one keystroke.
Most Excel users drag formulas down with the mouse, not realizing Ctrl+D fills the same range in one keystroke. Here is how to drag a formula in Excel using keyboard: select the formula cell, extend the selection downward, and press Ctrl+D. This article covers the exact step sequence, how to fill to the last row, what Mac users need to know, and what to check when Fill Down doesn’t work.
The Single Shortcut That Replaces Mouse Dragging
Ctrl+D is Microsoft’s official Fill Down command, documented for Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, and Excel 2016. It copies the formula from the active cell into every selected cell below it, adjusting relative references for each row. You do not need to touch the mouse at any point — the entire operation stays on the keyboard.
The same logic applies horizontally: Ctrl+R fills formulas to the right across selected cells.[11]
How to Use Ctrl+D Step by Step
The sequence requires exactly three actions: enter the formula, extend the selection, and press the shortcut. Here is the keyboard-only workflow Microsoft documents.
- Enter the formula in the first cell of the column where you want it to appear.
- Press Enter to confirm the formula and stay in that cell.
- Select the formula cell and the cells below it — hold Shift and press Down Arrow repeatedly to extend the selection, or hold Shift+Ctrl and press Down Arrow once to jump to the last contiguous cell with data (then press Shift+Up Arrow once to include the cell just above it).
- Press Ctrl+D. Excel copies the formula into every selected cell, adjusting relative references automatically.
The every cell in your selection now shows a value or result, and the formula bar displays the formula adjusted for each row.
Filling a Formula to the Last Row
The keyboard method most Excel power users rely on for filling to the bottom of a data set uses a quick selection jump. Start with the formula in the first cell of the column you want to fill. Press End then Down Arrow to jump to the last row of contiguous data in an adjacent column — or use Ctrl+Down Arrow — then press Ctrl+Shift+Up Arrow to extend the selection back up to your formula cell. Finally, press Ctrl+D to fill the entire range in one motion.
This pattern avoids scrolling through thousands of rows and works on any column where the adjacent data block defines the endpoint.
What About Mac Users?
On Excel for Mac, the equivalent keyboard shortcut is typically Cmd+D rather than Ctrl+D. The menu equivalent lives under Edit > Fill > Down. Some Mac users report the keyboard shortcut is less reliable for certain workflows, but the menu path always works when the shortcut does not.
Why Isn’t Ctrl+D Working?
When the shortcut produces no result or the wrong result, one of three things is usually the cause.
- No destination cells selected. Ctrl+D acts only on the current selection. If you press it without selecting cells below the formula, nothing happens or only the formula cell itself gets processed.
- Fill handle and drag-and-drop are disabled. Mouse dragging will not work, but Ctrl+D still can. If File > Options > Advanced > Editing Options > Enable fill handle and cell drag-and-drop is unchecked, re-enable it to restore both mouse and keyboard functionality.
- Workbook calculation is set to Manual. Open File > Options > Formulas > Calculation options > Workbook Calculation and confirm it is set to Automatic. Manual mode prevents formulas from updating after being filled.
| Fill-Down Method | Keyboard or Mouse | Best For |
|---|---|---|
| Ctrl+D (Fill Down) | Keyboard | Selected adjacent cells below the formula |
| Ctrl+R (Fill Right) | Keyboard | Selected adjacent cells to the right |
| Shift+Down Arrow + Ctrl+D | Keyboard | Keyboard-only selection of a short range |
| End + Down Arrow + Ctrl+Shift+Up Arrow + Ctrl+D | Keyboard | Filling to the last row of a data set |
| Double-click fill handle | Mouse | Auto-filling to the last adjacent cell with data |
| Drag fill handle | Mouse | Controlling the exact fill range by sight |
| Home > Fill > Down | Mouse + Menu | When keyboard shortcuts are unfamiliar |
How Excel Adjusts Your Formulas
When you fill a formula down, Excel changes relative references for each row. A formula in cell A1 that reads =B1+C1 becomes =B2+C2 in cell A2, then =B3+C3 in A3, and so on. This automatic adjustment is exactly what you want for column-based calculations — summing rows, applying rates, or concatenating values per row.
If you need a cell reference to stay fixed, use an absolute reference with dollar signs: =B1+$C$1 locks the reference to cell C1 no matter where the formula is filled. A mixed reference like =B$1 locks only the row, or =$B1 locks only the column. Understanding which reference type you used is the difference between a formula that fills correctly and one that silently produces wrong results.
Microsoft’s official Fill Down documentation describes this reference behavior in detail.
Common Keyboard Fill Mistakes
| Mistake | What Actually Happens | How to Avoid It |
|---|---|---|
| Pressing Ctrl+D with no range selected | Nothing changes, or only the current cell is processed | Always extend the selection before pressing the shortcut |
| Expecting identical formulas after filling | Relative references change row by row | Lock references with $ symbols where needed |
| Using the mouse-only mental model on a keyboard | The fill handle is ignored; no drag action occurs | Use Ctrl+D directly after selecting the range |
| Assuming Ctrl+D works on Mac | No action, or the wrong action fires | Use Cmd+D on Mac, or the Edit > Fill > Down menu |
| Workbook calculation set to Manual | Formulas appear but do not compute | Switch to Automatic in File > Options > Formulas |
The Keyboard Workflow That Replaces Dragging
Mastering the keyboard method for filling formulas down means you never have to reach for the mouse on a column fill again. The core sequence is always the same: type the formula, extend the selection downward, and press Ctrl+D. For filling to the last row of a data set, the selection jump with End and arrow keys takes the same amount of time as mouse scrolling but with more precision. On Mac, remember the shortcut is Cmd+D, with the menu path as a fallback. Once the selection and reference types are second nature, the keyboard method is faster and more reliable than dragging — especially across large worksheets.
References & Sources
- Microsoft Support. “Fill a formula down into adjacent cells.” Official documentation for the Fill Down shortcut, step sequences, and reference behavior.