In Excel for Microsoft 365 on Windows, select the cell or range that includes the top cell you want to copy, then press Ctrl+D to fill downward. For example, select C2:C20 when C2 contains the value or formula to repeat; Excel copies C2 down through the selected range.
How to use Ctrl+D in Excel
Fill Down takes the contents of the top cell in a selected range and copies them into the cells below it. The selection needs to include both the source cell and the destination cells. The top cell is the source; Excel does not automatically look one row above the selected range for a value to copy.
- Enter or identify the value, formula, or formatting in the top cell.
- Select that cell and the cells underneath where you want the copy to go. You can drag across the cells, use Shift with the arrow keys, or select a range in the Name Box.
- Press Ctrl+D on Windows.
For instance, if C2 contains a formula and the intended destination is C3 through C20, select C2:C20 before pressing the shortcut. If you select only C3:C20, Excel treats C3 as the source cell in that selection and fills its contents downward instead. If C3 is blank, the result may be a column of blanks rather than copies of C2.
Fill Down is useful for applying one entry to several rows quickly. It can also copy into a rectangular selection: when the selected range has several columns, Excel fills each column downward from that column’s own top cell.
What Fill Down copies
Ctrl+D copies the top cell’s contents and formatting to the other cells in the selected range. If the top cell contains a fixed value such as the word Pending, the cells below receive that same value. If it contains a formula, Excel copies the formula and adjusts relative references to suit each destination row. Formatting such as a number format, fill color, or font styling is copied as well.
The command does not calculate a sequence from a single starting value. For example, filling down from a cell containing 1 repeats 1; it does not automatically create 2, 3, 4, and so on. The same principle applies to dates: Fill Down repeats the top cell’s date rather than inferring a daily series. Use the fill handle or Excel’s series tools when you want Excel to extend a pattern instead of repeat the first cell.
Because the command copies the source cell, check that the top cell contains the right content and formatting before filling. If it is empty, filling down can replace existing entries in the selected cells with blanks. If the source cell has an unwanted format, that format may spread along with its contents.
Filling formulas down a column
One of the most common uses for Ctrl+D is copying a formula to the rows below it. Excel usually adjusts relative cell references as the formula moves. This is useful when each row should calculate from the data on that same row, such as a line total based on quantity and unit price.
Assume quantities are in B2:B4, unit prices are in C2:C4, and you want line totals in column A. With 3 and 12.50 in B2 and C2, enter this formula in A2:
=B2*C2
The result in A2 is 37.50. If B3 contains 2 and C3 contains 8, selecting A2:A4 and pressing Ctrl+D copies the formula down. In A3, Excel adjusts it to multiply B3 by C3, producing 16; the next row uses B4 and C4. The formulas remain live, so changing a quantity or price updates the total.
Relative references are not always what you want. If every row’s calculation should use a fixed rate in F1, lock that reference with dollar signs while leaving the row-specific reference relative. With quantities in B2:B4 and a rate in F1, enter the following in C2, then select C2:C4 and fill down:
=B2*$F$1
As the formula moves down, B2 changes to B3 and B4, while $F$1 stays fixed. Understanding this difference helps prevent formulas from pointing to the wrong cells after filling.
Fill several columns or a larger range
You can use Ctrl+D on more than one column at once. Suppose row 2 contains formulas or entries in B2:D2, and you want each column’s top entry copied into rows 3 through 10. Select B2:D10 and press Ctrl+D. Excel fills column B from B2, column C from C2, and column D from D2. It does not copy the contents of B2 across all three columns.
This behavior makes the command handy when a worksheet has several calculated columns that follow the same row-by-row pattern. Before filling a wide range, inspect the entire top row of the selection. Every column uses its own top cell as the source, so a blank or incorrect cell in that row can produce an unexpected result in that column.
For a large range, you can select it without scrolling through every row. Click the Name Box to the left of the formula bar, type a range such as B2:D500, and press Enter. The range becomes selected; pressing Ctrl+D fills each column from its top cell. This approach is particularly useful when the destination extends hundreds or thousands of rows.
Other ways to fill down
The keyboard shortcut is fast, but it is not the only way to use the command. Excel’s ribbon provides the same Fill Down operation. Select the source cell and destination range, then choose Home > Editing > Fill > Down. The ribbon is a useful fallback if you cannot remember the shortcut or if another application or keyboard setup interferes with it.
The fill handle is the small square at the lower-right corner of the active cell or selected range. Drag it down to copy or extend content. What Excel does depends on the content and how you drag: it may copy a value or formula, or recognize a pattern such as a numbered series. That makes it useful when extending a sequence, but it can be less predictable than Ctrl+D when the exact goal is simply to copy the top cell.
Copy and paste is another alternative. Copy the source cell, select the destination cells, and paste. This offers paste options, such as choosing whether to include formatting, but it takes more steps. Ctrl+D is usually more direct when the source is already the first cell of the selected range and you want to fill downward.
Windows, Mac, and Excel for the web
In Excel for Microsoft 365 on Windows, the Fill Down shortcut is Ctrl+D. On Excel for Mac, use Command+D for Fill Down. The keyboard modifier differs because Mac applications use Command where Windows applications commonly use Ctrl. If a shortcut behaves unexpectedly, confirm that Excel has focus and that you are not currently editing text inside a cell; press Enter or Esc to finish editing, select the range, and try again.
Excel for the web also provides Fill Down for selected cells, and Ctrl+D is available in supported browser and keyboard setups. Browser shortcuts or platform differences can sometimes get in the way, so the ribbon command, Home > Fill > Down, is a practical alternative when the key combination does not work. Menu and ribbon layouts can vary slightly as Microsoft updates the web app, but the Fill Down command works on the selected range in the same basic way.
Common problems and how to fix them
- The cells below did not copy the cell above. Check the selection’s first row. The top cell of the selected range is the source. Include the cell you want to copy before pressing Ctrl+D.
- The formula shows the wrong references. Relative references shift as the formula is copied. Use dollar signs to lock a row, column, or both where needed, and check the resulting formula in a destination cell.
- A series became repeated values. Fill Down copies the top cell; it does not necessarily extend a pattern. Use the fill handle or a series command when you need consecutive numbers or dates.
- Formatting changed unexpectedly. Fill Down copies formatting from the top cell too. If you want to keep destination formatting, consider copying and using a paste option that excludes formatting, or apply the desired formatting afterward.
- Nothing happened or the shortcut did something else. Make sure the worksheet is active, the intended range is selected, and cell editing is complete. On a laptop, check whether a keyboard setting or another application is capturing the key combination; use the ribbon command as a fallback.
Also remember that filling down overwrites the selected destination cells. If they contain data you need, make a copy of the worksheet or verify the range before applying the command. Undo with Ctrl+Z on Windows or Command+Z on Mac if you fill the wrong range and have not performed an action that prevents undo.
Frequently Asked Questions
What is the Fill Down shortcut in Excel?
In Excel for Microsoft 365 on Windows, select a range that includes the top source cell and press Ctrl+D. On a Mac, use Command+D. The command copies the top cell downward through the rest of the selection.
Do I select the cell above the blank cells before pressing Ctrl+D?
Yes. Include the source cell as the first, top cell in your selection. For example, to copy C2 into C3:C10, select C2:C10. Selecting only C3:C10 makes C3 the source instead.
Does Ctrl+D copy formulas or just their displayed results?
It copies the formula itself, not merely the displayed result. Relative references usually adjust for each row, while absolute references marked with dollar signs stay fixed. If the top cell contains a constant rather than a formula, that value is copied.
Can Ctrl+D fill multiple columns at once?
Yes. Select a range that includes the source row and the destination rows. Excel fills each column from its own top cell. For example, selecting B2:D10 fills column B from B2, C from C2, and D from D2.
Why does Ctrl+D repeat a number instead of counting up?
Fill Down copies the top cell; it does not infer a number sequence from one value. To create a sequence such as 1, 2, 3, enter enough starting values for Excel to recognize the pattern and use the fill handle, or use Excel’s series-filling tools.
Related
- Export to CSV vs Excel: Which Format Should You Choose?
- Extract Data from Google Maps to Excel: Practical Options
- Export Excel to Word: Methods and Formatting Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Archive Deleted Emails in Outlook SafelyTo archive an email that is in Outlook’s Deleted Items folder, select it and move it to the…
- PowerPoint Speaker Notes: Where to Add and View ThemAdd speaker notes in the Notes pane beneath the slide: in PowerPoint for Microsoft 365 on Windows, open…
- How to Highlight Half a Cell in Excel with a ShapeExcel does not have a built-in command to fill only half of a cell. To create that effect,…
- Excel Page Breaks: How to Remove or Hide ThemTo remove manual page breaks in Excel for Microsoft 365 on Windows, select Page Layout > Breaks >…
- MT5 History to Excel: Export Trades and Account DataTo export MT5 history to Excel, open the desktop terminal’s Toolbox with Ctrl+T, select History, set the date…
- Advanced Excel Dashboards: Design, Build, and MaintainAn advanced Excel dashboard is an interactive, refreshable view of important measures, built from organized source data using…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.