Excel Shortcut to Pull Down a Formula: Fill Down Fast

In Excel for Microsoft 365 on Windows, select the formula cell and the cells below where you want it copied, then press Ctrl+D to fill down. Include the original formula cell at the top of the selected range; Excel copies its contents downward and adjusts relative cell references for each row.

Use Ctrl+D to fill a formula down

Excel calls this command Fill Down. It is useful when a formula needs to be repeated through a column, and it avoids dragging the fill handle row by row. The essential detail is the selection: the top row must contain the formula you want to copy, and the rows beneath it should be the destination.

Enter the formula in the first cell of the column, such as D2.
Select the range from that cell through the last destination cell, such as D2:D20. You can drag over the cells or click D2, hold Shift, and click D20.
Press Ctrl+D. Excel fills the selected cells below the top cell.

The shortcut copies the top cell into every lower cell in the selected range. It can copy values, text, and formatting as well as formulas, so check that you have selected only the cells you intend to replace. If you select only the blank cells below the formula, the first selected cell is blank and Excel has no formula at the top of the range to copy.

What Fill Down does to formulas

When Excel copies a formula down one or more rows, it normally changes relative references to match the destination row. This behavior is why a single formula can calculate a separate result for each record. For example, suppose each row contains a quantity and a unit price. With quantity in B2, unit price in C2, and the result intended for D2, enter =B2*C2 in D2. If B2 contains 3 and C2 contains 12.50, D2 returns 37.50. Filling D2 down to D3 changes the references to B3 and C3, so the next row uses its own data.

This reference adjustment is automatic; you do not need to rewrite the formula for every row. However, Excel copies the formula pattern, not a promise that every result will be meaningful. A blank input may produce zero or another result depending on the formula, and a copied formula may point to the wrong cells if the original formula was built incorrectly. Review a few filled rows, particularly when the formula includes several references or mixed references.

Keep a reference fixed when needed

Sometimes one part of a formula should stay pointed at the same cell as you fill down. For instance, a tax rate or discount factor might be stored once in B1 while each row has a different amount in C2, C3, and so on. With the rate in B1, the amount in C2, and the calculation in D2, enter =$B$1*C2. If B1 is 10% and C2 is 200, the result is 20. When filled down, the reference to B1 stays fixed while the relative reference to the amount advances to C3, C4, and subsequent rows.

The dollar signs make a reference absolute. You can also lock only the column or only the row when that suits the layout; those are called mixed references. In Windows Excel, while editing a formula, select a cell reference and press F4 to cycle through reference types. On some laptops you may need Fn+F4, depending on the keyboard’s function-key settings. If a reference moves unexpectedly after filling, inspect whether it should have been locked before copying.

Choose between the shortcut, the fill handle, and the ribbon

Ctrl+D is usually the quickest choice when you know the exact range. Other methods can be more convenient in different situations:

Fill handle: Select the formula cell and drag the small square at its lower-right corner down the column. This is handy when you want to see or choose the endpoint visually.
Double-click the fill handle: Excel can extend the formula alongside a neighboring column of data. The adjacent data helps Excel estimate how far to fill, so this method is less predictable if that column has gaps or ends at a different row.
Ribbon command: Select the range with the formula at its top, then choose Home > Fill > Down. This performs the same Fill Down operation as the shortcut.
Copy and paste: Copy the formula cell, select the destination range, and paste. This can be useful if you need to copy between separate areas, but ordinary paste also brings other cell content or formatting depending on the paste method.

For a small table, dragging may feel easiest. For a long, precisely bounded range, selecting the range and using Ctrl+D is often more controlled. Double-clicking is convenient when a neighboring column reliably marks the last data row, but check the bottom of the filled column afterward.

Fill several columns or a large range

Fill Down can handle a rectangular range, not just one column. If the top row of each selected column contains the appropriate formula or value, select the whole rectangle and press Ctrl+D. Excel fills each column from its own top cell. This can save time when a table has several calculated columns, but it also means any existing values or formulas lower in the selection will be overwritten.

For a very long worksheet, use the Name Box to select a range directly. The Name Box is to the left of the formula bar; enter a range such as D2:D5000 and press Enter, then press Ctrl+D. Confirm the starting cell and endpoint before filling, especially in a workbook where lower rows contain notes or separate data. A shortcut acts immediately on the selected cells and does not show a separate confirmation prompt.

It is also possible to fill down across multiple columns where some top-row cells contain formulas and others contain labels or values. Each column uses its own top cell as the source. That flexibility is useful for repeating a complete row pattern, but it is another reason to select deliberately rather than highlighting an entire worksheet column without checking what lies below.

Common fill-down problems and fixes

The formula did not copy: Check that the selected range starts with the formula cell. If you selected only the cells below it, select again from the formula cell through the destination and repeat the command.
Existing cells changed: Fill Down replaces content in the lower selected cells. Undo immediately with Ctrl+Z if the change was accidental, or restore the original data from a saved copy if the workbook has since been changed.
Every row shows the same result: Look at the references in the formula. They may be absolute when they need to move, or the formula may refer to a fixed input intentionally. Also check whether calculation is set to Automatic under Formulas > Calculation Options.
Results look wrong after filling: Click a few cells in the middle and at the bottom of the filled range and inspect the formula bar. A missing dollar sign, an incorrect starting row, or a gap in the source data can explain unexpected references or outputs.
The shortcut seems to do nothing: Make sure Excel has focus and that a cell range is selected. If you are editing a cell, finish or cancel the edit first. Check that another application or a custom keyboard mapping is not intercepting the keystroke.

Also distinguish copying from a sequence. Ctrl+D copies the top cell’s contents down; it does not infer a new series from two starter values in the way some fill operations can. If a formula is what you need repeated, use Fill Down. If you want Excel to continue a number or date pattern, use the fill handle or the Fill Series options and verify the pattern it produces.

Windows, Mac, and Excel for the web

On Windows desktop Excel, the Fill Down keyboard shortcut is Ctrl+D. In Excel for Mac, use Control+D for Fill Down; the Control key is distinct from Command. The ribbon route, Home > Fill > Down, is an alternative on either desktop platform when the keyboard shortcut is inconvenient. Keyboard behavior can vary with a Mac keyboard or system settings, so use the ribbon command if the shortcut is captured elsewhere.

Excel for the web also provides the Home tab’s Fill Down command, and Ctrl+D is available in many browser and keyboard configurations. Because browser shortcuts and keyboard layouts can affect keystrokes, the ribbon route is a dependable fallback. The selection rule remains the same: include the source cell at the top of the range and the destination cells below it.

Frequently Asked Questions

What is the keyboard shortcut to drag a formula down in Excel?

Use Ctrl+D on Windows, or Control+D on Mac, after selecting the formula cell and the cells below it. Strictly speaking, the shortcut fills the selected range; it does not drag the formula. The fill handle is the on-screen method you drag.

Can I fill a formula down without changing its references?

Yes. Make the references you want to keep fixed absolute by adding dollar signs before the column letter and row number. Leave references relative when they should adjust for each row. You can mix fixed and changing references in the same formula.

How do I copy a formula to the bottom of adjacent data?

Enter the formula in the first row, then double-click its fill handle. Excel usually fills alongside the neighboring column’s continuous data. If that column contains blanks or does not extend as far as your table, select the destination range manually and use Ctrl+D instead.

Does Ctrl+D fill down formatting too?

Yes. Fill Down copies the top cell’s contents and formatting to the cells below in the selected range. If you only want a formula or value without all formatting, consider using Paste Special options or adjust the formatting afterward.

Why is Ctrl+D filling a blank or the wrong formula?

The top cell of the selected range is the source for Fill Down. If the range starts on a blank or an unintended cell, Excel copies that cell’s contents instead. Reselect the range with the intended source formula at the top, and check that lower cells can safely be overwritten.

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.