Excel Shortcut to Drag a Formula Down

In Excel for Microsoft 365 on Windows, select the cell with the formula and the cells below it, then press Ctrl+D to fill the formula down. If you mean literally dragging with the mouse, use the cell’s fill handle at its lower-right corner; Ctrl+D is the keyboard shortcut for the equivalent Fill Down command.

The keyboard shortcut for Fill Down

Ctrl+D copies the contents and formatting of the top cell in a selected range into the cells beneath it. For a formula, Excel adjusts relative cell references as it fills, much as it does when you drag the fill handle. The shortcut is useful when the destination range is long, when you want to avoid precise mouse movement, or when you already know exactly how far the formula should go.

The essential detail is that the source formula must be at the top of the selection. For example, if the formula is in D2 and you want it through D20, select D2:D20 first. Pressing Ctrl+D then uses D2 as the source and fills the rest of the selected cells. If you select only D3:D20, Excel uses D3 as the source instead; it does not look above the selection for a formula to copy.

How to fill a formula down step by step

Enter the formula in the first cell of the range, such as D2.
Select that cell and every destination cell below it. You can drag across the range, click the first cell and Shift-click the last, or select the first cell and use the name box to enter a range such as D2:D500.
Press Ctrl+D. The formula from the first row is filled into the remaining selected rows.
Check a lower cell to confirm that the formula references the intended row and that the result looks reasonable.

You can also select a range using the keyboard: click the formula cell, hold Shift, and press the Down Arrow to extend the selection. For a large range, entering the range in the Name Box (to the left of the formula bar) is often quicker and more exact than repeatedly pressing an arrow key. Make sure the range includes the source cell at the top.

What happens to formula references

Excel normally treats cell references as relative when copying a formula. That means the reference changes according to how far the formula moves. Suppose quantities are in B2:B4, unit prices are in C2:C4, and the total for each row belongs in column D. With quantity in B2 and price in C2, enter this in D2:

With quantities in B2:B4 and unit prices in C2:C4, enter this formula in D2; for example, 3 items at 12 each return 36:

=B2*C2

After filling down, the formula in D3 becomes =B3*C3, and the formula in D4 becomes =B4*C4. The displayed results depend on the values in those rows. This relative adjustment is why a single formula can calculate each row without manually editing the row numbers.

Dollar signs make a reference absolute or partly absolute. If a tax rate is in F1 and you want each row’s amount multiplied by that same rate, lock the rate reference before filling down. With amounts in B2:B4 and the tax rate in F1, put this in C2:

With amounts in B2:B4 and a fixed tax rate in F1, enter this formula in C2; if B2 is 100 and F1 is 8%, the result is 8:

=B2*$F$1

Filling down changes B2 to B3, B4, and so on, while $F$1 stays fixed. A reference such as F$1 locks only the row, while $F1 locks only the column. Use these mixed references when copying both down and across requires one dimension to remain fixed.

Ctrl+D compared with dragging the fill handle

Ctrl+D and the fill handle both fill formulas, but they suit different situations. Ctrl+D is a direct command for a range you select yourself. The fill handle is the small square at the lower-right corner of the active cell; dragging it lets you visually choose an ending row. Both methods usually adjust relative references and preserve absolute references.

Use Ctrl+D when you know the destination range, want a keyboard-only method, or need to fill a large selected block.
Drag the fill handle when the destination is short or you want to see where the fill ends.
Double-click the fill handle when data in a neighboring column can guide Excel to the likely last row. Excel typically fills alongside that neighboring data, but gaps or an unsuitable adjacent column can make the endpoint differ from what you expect.

Dragging is not itself a keyboard shortcut. If you want to start a fill with the keyboard and avoid dragging, select the source and destination cells and use Ctrl+D. You can also use the Ribbon command Home > Fill > Down, which performs the same basic Fill Down action.

Filling formulas in tables and larger ranges

In a regular worksheet range, select the formula cell and the destination cells, then use Ctrl+D. In an Excel table, entering a formula in a table column often causes Excel to create a calculated column and fill the formula through the table automatically. If that does not happen, check whether the cells are actually part of a table and whether the intended rows are included; Ctrl+D remains an option for a selected range.

For a very large dataset, avoid selecting an entire worksheet column automatically unless that is really what you intend. Selecting D:D and using Fill Down could copy the top cell throughout the column, including far beyond the rows containing data. A bounded range, such as D2:D5000, is easier to verify and avoids filling thousands of unwanted cells.

When filling more than one column, Ctrl+D fills downward within each selected column, using the top cell of that column as its source. For example, selecting D2:E20 fills D3:D20 from D2 and E3:E20 from E2. This can be helpful for adjacent formulas, but it also means the top row of every selected column matters.

Common problems and how to fix them

The formula did not fill where expected: Check that the source cell is the top row of the selection. Re-select a range that starts at the formula cell and includes all intended destination cells, then press Ctrl+D.
Every row shows the same result: Inspect the formula references. A reference such as $B$2 is fixed, so it will keep pointing to B2 when copied. If each row should use its own value, use a relative reference such as B2 instead.
The result is wrong only in some rows: Look for blank cells, text stored where numbers are expected, or formulas that should use a fixed reference but do not. Compare the formula in a correct row with the formula in a problem row using the formula bar.
The shortcut does something else: Confirm that Excel has focus and that the range is selected. On Windows, Ctrl+D is Fill Down in Excel. In a browser or a workbook opened in another application, a shortcut may be intercepted or behave differently.
Existing cells were overwritten: Fill Down replaces the contents of the lower selected cells with copies based on the top row. If those cells contain data you need, undo immediately with Ctrl+Z, then choose a clear destination range or copy the source to a safe area first.

One frequent misconception is that Ctrl+D automatically finds the bottom of a list. It does not: it fills the range you selected. The double-click fill handle can infer an endpoint from nearby data, but Ctrl+D needs an explicit selection, so check the highlighted range before using it.

Windows, Mac, and Excel for the web

In Excel for Microsoft 365 on Windows, use Ctrl+D. In Excel for Microsoft 365 for Mac, the corresponding Fill Down shortcut is Command+D. The source-at-the-top rule and the need to select the destination range are the same. If a Mac keyboard or system setting intercepts a shortcut, use the Ribbon command Home > Fill > Down instead.

Excel for the web also offers Fill Down, though browser shortcuts and keyboard focus can affect what happens when keys are pressed. If Ctrl+D does not fill the selected range there, use the Home tab’s Fill command or the mouse fill handle. These instructions describe Excel; other spreadsheet applications may use different commands or shortcut behavior.

Frequently Asked Questions

What is the shortcut to drag a formula down in Excel?
There is no keyboard shortcut that performs the physical mouse-drag action. To achieve the same result with the keyboard, select the formula cell and the cells below it, then press Ctrl+D on Windows or Command+D on Mac.

Do I select the formula cell too when pressing Ctrl+D?
Yes. Include the formula cell as the top row of the selection, along with every cell you want to fill. Excel copies from that top cell into the selected cells below it.

Does Ctrl+D change cell references automatically?
Yes, relative references normally adjust as the formula moves down. Absolute references marked with dollar signs, such as $F$1, stay fixed. Mixed references lock only the row or column marked with a dollar sign.

Can I fill a formula down without dragging?
Yes. Select the source formula and destination range, then press Ctrl+D on Windows or Command+D on Mac. You can also choose Home > Fill > Down.

Why does Ctrl+D copy the same formula reference into every row?
The formula may contain an absolute reference, or the selection may be starting from a cell whose formula already points to a fixed location. Check the dollar signs in the formula and compare the top and lower cells before changing the reference style.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.