Excel Shortcut to Copy Down: Ctrl+D Explained

In Excel for Microsoft 365 on Windows, select the range you want to fill, including the cell at the top that contains the content, then press Ctrl+D. Excel copies that top cell down through the rest of the selected range.

The quick way to copy down

For example, if D2 contains a value or formula and you want it repeated or adjusted through D20, select D2:D20 and press Ctrl+D. The top cell must be part of the selection: if you select only D3:D20, Excel uses D3 as the source instead. The command works with a single column or with a rectangular range covering several columns.

You can also use the ribbon: choose Home > Editing > Fill > Down. The ribbon command and Ctrl+D perform the same Fill Down operation, so the keyboard shortcut is usually the fastest option when your selection is ready.

What Ctrl+D does

Ctrl+D is Excel’s Fill Down command. It takes the contents and formatting of the top row of the selected range and fills them into the rows below. If the selected range has several columns, Excel fills each column from its own top cell. For instance, selecting B2:D8 fills B3:B8 from B2, C3:C8 from C2, and D3:D8 from D2.

Fill Down is not the same as pressing Ctrl+C and Ctrl+V, even though both can copy content. Ctrl+D works directly on the selected range and does not require you to start or manage a clipboard copy. It also has a clear direction: the source is the top row, and the destination is below it. To fill horizontally from the leftmost cell instead, use Ctrl+R on Windows.

The shortcut does not infer a series from the first two entries. If the top cell contains the number 5, filling down generally copies 5; it does not automatically create 6, 7, and 8. Use the fill handle or a series-filling command when you want a sequence rather than repeated content.

Select the right range first

The most important step is to select both the source cell and every destination cell. The selection can be made with the mouse, keyboard, or Name Box. If a worksheet has many rows, the Name Box to the left of the formula bar is useful: enter a range such as D2:D1000, press Enter, and then press Ctrl+D.

For a keyboard-only selection, click the source cell, then extend the selection down with Shift and the arrow keys. You can also use Ctrl+Shift+Down to extend through a contiguous block of data, but check the highlighted range before filling: Excel stops at blank cells, and the selected block may not end where you expect.

For one column, select the source and the cells beneath it, such as A2:A25.
For multiple columns, select a rectangle, such as B2:D25; the first row supplies each column’s source.
To fill only a few separated cells, use a method suited to a noncontiguous selection rather than assuming Ctrl+D will treat them as one continuous range.

Be deliberate about the top row. If it is blank, Fill Down can replace the selected cells below with blank content. If it contains an old value or an unintended formula, that is what Excel will fill. Confirm the source cell and selection before using the shortcut on important data.

How formulas change when filled down

When the source cell contains a formula with relative references, Excel adjusts those references as it fills down. With prices in B2:B4, quantities in C2:C4, and the first total in D2, enter =B2*C2 in D2. Select D2:D4 and press Ctrl+D. D3 then uses B3 and C3, and D4 uses B4 and C4.

For a concrete example, suppose the prices are 12.50, 8.00, and 2.25, while the quantities are 3, 5, and 4. The filled formulas return 37.50, 40.00, and 9.00 in D2:D4. Excel has copied the calculation pattern, not the original result as a fixed number.

Reference types matter. A relative reference such as B2 moves as the formula is filled. An absolute reference such as $B$2 stays fixed, while a mixed reference such as B$2 fixes the row but allows the column to change. This makes Fill Down useful for formulas that should update by row, but it can also expose a formula that was anchored incorrectly. If results look wrong, inspect the formula in a lower row rather than checking only the displayed value.

What gets copied: values, formulas, and formatting

Fill Down copies the top cell’s contents and formatting into the remaining selected cells. Contents can be a typed value, text, a formula, or a blank. Formatting can include things such as number format, font, fill, and borders. This means the shortcut is convenient for carrying a consistent formula and appearance down a column, but it may also replace formatting that was intentionally different in the destination cells.

If you need the formula or value but want to preserve the destination formatting, Ctrl+D may not be the best choice. You can copy the source and use Paste Special options to choose what to paste, or fill the range and then restore the desired formatting. The exact Paste Special choices depend on what was copied and on the Excel version, so check the dialog or paste options displayed in your installation.

Likewise, a blank source cell is not a neutral instruction to leave the cells below alone. Filling from that blank can clear existing contents in the destination range. If you want to fill only some cells while preserving others, narrow the selection or use a method that targets those cells specifically.

Other ways to fill down

Ctrl+D is efficient, but it is not the only way to copy content down. Choose the method that matches the size of the range and whether you need to control formatting or create a sequence.

Fill handle: Select the source cell and drag the small square at the lower-right corner of its selection down the destination range. Depending on the content and how you drag, Excel may copy the value or formula, or extend a recognizable series. Review the result when sequence behavior matters.
Copy and paste: Copy the source with Ctrl+C, select the destination, and paste with Ctrl+V. This is familiar and gives access to paste options, but it involves more steps for a simple contiguous fill.
Ribbon command: Use Home > Editing > Fill > Down when you prefer menus or cannot use the keyboard shortcut.
AutoFill in a table: In an Excel table, entering a formula in a calculated column may cause Excel to extend it to other rows in that column. If the table does not fill as expected, check the existing column contents and Excel’s table behavior before filling manually.

For a repeated formula in a long continuous column, Ctrl+D is often straightforward. For a number series, dates, or a pattern that should continue rather than repeat, use the fill handle or the appropriate series options and verify the generated values.

Windows, Mac, and Excel for the web

This article’s main shortcut is for desktop Excel on Windows: Ctrl+D. In Excel for Mac, use Command+D for Fill Down. The key labels differ, but the basic selection rule is the same: include the source cell at the top and the destination cells below it.

Excel for the web also provides Fill Down, but browser and operating-system shortcut behavior can affect which keystrokes are captured. If Ctrl+D does not act on the worksheet in your browser, use the ribbon’s Fill Down command instead. Make sure the worksheet grid has focus and verify the result, particularly when using a browser with its own shortcut that may compete for the same keys.

Common problems and how to fix them

Nothing changes: Check that you selected more than one cell and that the source cell is included. If the selection begins below the source, Ctrl+D fills from the first selected row, not from a cell above the selection.
Every row shows the same number: The top cell may contain a fixed value rather than a formula, or the formula may use absolute references. Check the formula bar and the reference symbols.
Formulas show errors or unexpected results: Look at the formula in a filled row to see how references shifted. Also check whether the source formula already points to the intended cells.
Formatting changed: Fill Down copied the top cell’s formatting. Use a paste option that preserves destination formatting, or reapply the formatting after filling.
Existing data disappeared: The selected range may have been too large, or the source cell may have been blank. Undo immediately with Ctrl+Z on Windows if the fill was accidental and the action is still available in the undo history.

Before filling a large or important range, inspect the first few destination cells and confirm that both the contents and formatting are appropriate. If the worksheet is protected, Excel may prevent changes to locked cells; you may need permission or an unprotected range. Merged cells can also complicate range operations, so avoid including merged areas unless the selection and merge layout are compatible.

Frequently Asked Questions

What is the keyboard shortcut to copy a cell down in Excel?
On Windows, select the source cell and the cells below it, then press Ctrl+D. On Mac, use Command+D. Include the top source cell in the selection.

How do I copy a formula down without changing the references?
Use absolute references, such as $B$2, for references that must stay fixed when filled. Relative references move as the formula is copied. You can also copy and paste a formula, but its relative references normally adjust in the same way.

Does Ctrl+D copy formatting too?
Yes. Fill Down copies the top cell’s contents and formatting through the selected range. If you need to preserve the destination formatting, use a suitable Paste Special option or reapply the formatting afterward.

How do I fill down without a mouse?
Select the source cell and the cells beneath it using the keyboard, then press Ctrl+D on Windows. On Mac, press Command+D. You can also enter a range in the Name Box and run the shortcut.

What is the difference between Ctrl+D and dragging the fill handle?
Ctrl+D copies the top row of a selected range down. The fill handle can copy content too, but it may extend a recognizable number or date series depending on the selection and drag. Use Ctrl+D when you want a direct fill from the selected range’s top row.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.