To copy down in Excel, enter or select the content in the top cell, select the cells below it, then press Ctrl+D on Windows. You can also drag the fill handle—the small square at the selected cell’s lower-right corner—down the column. These methods copy a value, formula, and often formatting; prepare the destination cells first so you do not overwrite information you need.
What You’ll Need
- An Excel workbook in Microsoft 365 for Windows. The steps also work in recent desktop versions of Excel.
- A source cell containing the value, formula, or formatting you want to repeat, plus a destination range beneath it.
- If you plan to use the fill handle, make sure it is enabled. In Windows Excel, check File > Options > Advanced and confirm Enable fill handle and cell drag-and-drop is selected.
You do not need to install an add-in. If your worksheet is protected, or the cells are part of a merged range, you may need to resolve that restriction before filling.
Step-by-Step
-
Choose the cell to copy. Click the top cell that contains the content you want repeated. This can be a typed value, a formula, or a cell with formatting. If you are copying a formula, check that its references are set up the way you intend before filling. The fill operation uses the top cell in the selected range as its source.
-
Select the destination cells. Include both the source cell and the blank cells below it. For example, if the source is A2 and the destination should extend through A12, select A2:A12. You can drag over the range, or click A2, hold Shift, and click A12. To select a range by address, click the Name Box to the left of the formula bar, type A2:A12, and press Enter.
Including the source cell matters: Excel needs to know which cell’s content to use. Selecting only A3:A12 and pressing Ctrl+D may fill from the first row of that selection, which is A3, not from A2.
-
Use the Fill Down shortcut. With the source and destination selected, press Ctrl+D on Windows. Excel copies the top cell’s contents down through the selected range. If you are using Excel for Mac, try Control+D; keyboard behavior can vary with the keyboard and system settings. If that shortcut is intercepted or does not work, use the ribbon method in the next step.
For a quick example, suppose A2 contains the text Pending and you select A2:A12. Ctrl+D repeats Pending in each selected cell. If A2 contains a formula, Excel fills the formula down and normally adjusts relative references for each row.
-
Or use the ribbon command. Select the source and destination range, then choose Home > Fill > Down. In some ribbon layouts, Fill appears in the Editing group on the Home tab. This is a useful alternative if you forget the shortcut, are using a device where the keyboard shortcut differs, or are working in Excel for the web. The command fills the selected cells using the top cell.
-
Or drag the fill handle. Click the source cell and point to its lower-right corner until the pointer changes to a small black plus sign. Drag the handle down to the last destination cell, then release. Check the resulting cells, especially if the source is a number or date: Excel may extend a series rather than make an exact copy. The Auto Fill Options button that appears after dragging lets you choose a different fill behavior when available.
-
Use double-click for a long adjacent list. If the source cell contains a formula and there is a continuous block of data beside it, double-click the fill handle instead of dragging down many rows. Excel usually fills the formula alongside that neighboring data. For instance, if column B has entries from B2 to B80 and C2 contains a formula, double-clicking C2’s fill handle can fill column C down alongside the entries. Check the last row: blank cells or gaps in the neighboring column can affect how far Excel fills.
-
Check formulas and formatting. Click a few filled cells and inspect the formula bar. Confirm that references point to the intended row and that the last destination cell was included. If you used the fill handle, click the Auto Fill Options button if it is visible and choose an option such as Copy Cells or Fill Without Formatting to get the result you want.
For a formula example, suppose column B contains item prices, F1 contains a fixed rate of 8%, and C2 is meant to calculate that rate for the value in B2. With B2 equal to 12 and F1 equal to 0.08, enter =B2*$F$1 in C2; the result is 0.96. Select C2:C3 and fill down. In C3, Excel adjusts the relative B2 reference to B3 but keeps the absolute reference to F1. If B3 is 20, the copied formula returns 1.6. The dollar signs lock F1 so it does not shift as the formula is copied.
Common Mistakes
- Selecting the wrong starting cell: The top cell of the selected range is the source for Fill Down. Include the original cell at the top, rather than selecting only the empty cells beneath it.
- Overwriting existing data: Fill Down replaces the contents of destination cells. Before filling, confirm that the selected range does not contain notes, values, or formulas you need to keep. Undo with Ctrl+Z immediately if you fill over the wrong range.
- Expecting a number or date to behave like text: Dragging a single number may copy it, while dates or a selected pattern can extend as a series. If you need an exact repeat, use Ctrl+D or choose Copy Cells in Auto Fill Options.
- Assuming every formula reference should move: Relative references change as a formula is copied; absolute references marked with dollar signs stay fixed. Mixed references lock only the row or column. Review the formula bar in a few destination cells to confirm the references behave as intended.
- Filling through hidden or filtered rows without checking: A selected range can include rows that are not currently visible. Review the range and the result before relying on a fill in a filtered or grouped worksheet.
- Ignoring formatting changes: Filling can copy the source cell’s formatting along with its contents. If the destination cells have different number formats, borders, or colors, use the fill options to preserve or change formatting as needed.
Tips
- Use Ctrl+D for a precisely selected range. It is usually the clearest choice when you want an exact copy of the top cell’s contents down a known number of rows.
- Use the Name Box for large ranges. Typing a range such as D2:D500 into the Name Box is faster and less error-prone than dragging across hundreds of rows. Select the whole range, including the source, before using Fill Down.
- Choose the fill behavior deliberately. When dragging produces an unwanted sequence or formatting, use the Auto Fill Options button. Copy Cells repeats the source; Fill Series extends a recognizable pattern; Fill Without Formatting keeps the content fill but avoids copying the source’s formatting.
- Consider an Excel Table for recurring formulas. In a table, entering a formula in a calculated column often fills it through the column automatically. Tables are useful for lists that grow over time, but check that the formula is consistent throughout the column.
- Keep a source row intact. Before filling a long range, verify the source cell and try the operation on a small range. This makes it easier to spot incorrect references or formatting before they spread through the worksheet.
Troubleshooting
Ctrl+D does nothing: Confirm that Excel is active and that you selected a range containing the source cell and at least one destination cell below it. Try Home > Fill > Down. On a Mac, use Control+D if supported by your setup, or use the ribbon command. In Excel for the web, a browser or operating-system shortcut may take precedence, so the ribbon is a dependable alternative.
The fill handle is missing: In Windows desktop Excel, open File > Options > Advanced. Under Editing options, turn on Enable fill handle and cell drag-and-drop. If the setting is on but dragging still fails, check whether the worksheet is protected or the selected cells are merged. You can use the ribbon Fill Down command instead when appropriate.
The formula gives the wrong result after filling: Select one of the affected cells and inspect its formula in the formula bar. If a reference that should stay fixed has shifted, edit the source formula to use an absolute reference, such as $F$1, then fill again. If a reference should move but remains fixed, remove the dollar sign from the row or column that needs to change.
Excel filled too far, or stopped too soon: Undo the operation with Ctrl+Z, check the selected range, and repeat. For double-clicking the fill handle, look for gaps in the adjacent column; Excel uses neighboring data to estimate the fill length. Dragging to a specific row or selecting a range by address gives you more direct control.
The cells contain a sequence instead of repeats: Undo the fill if necessary. Select the source and destination range and use Ctrl+D or Home > Fill > Down for an exact downward copy. If you used the fill handle, choose Copy Cells from Auto Fill Options instead of Fill Series.
Formatting changed unexpectedly: Use the Auto Fill Options button and select Fill Without Formatting, if offered. Alternatively, fill the contents first, then apply the destination’s desired number format or style. If the cells are merged, unmerge them before filling; merged ranges can prevent standard fill operations.
Frequently Asked Questions
What is the shortcut to copy down in Excel?
On Windows, select the source cell and the cells beneath it, then press Ctrl+D. On Mac, Control+D is the usual Fill Down shortcut, though system or keyboard settings can affect it. Home > Fill > Down is an alternative.
How do I copy a formula down without changing its references?
Use absolute references for the parts that should stay fixed. For example, $F$1 keeps both the column and row fixed when copied. A mixed reference such as F$1 locks only the row. Fill the formula down, then inspect the results.
How do I copy a cell down without copying its formatting?
Drag the fill handle and choose Fill Without Formatting from Auto Fill Options when that option appears. You can also fill the content, then restore the destination cells’ number format, borders, or other styling.
Can I copy down several columns at once?
Yes. Select the source row and the destination rows across all the columns you want to fill, then press Ctrl+D or choose Home > Fill > Down. Each column uses its own top cell as the source, so check that every top cell contains the intended content.
Why does double-clicking the fill handle stop early?
Double-click fill uses nearby data to estimate where the list ends. A blank or gap in the adjacent column can make Excel stop before the last row. Drag the handle to the required row or select the full range and use Fill Down instead.
Related
- How to Combine Cells in Excel Without Losing Data Safely
- How to Combine Columns in Excel Without Losing Data
- How to Combine CSV Files in Excel with Power Query
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets COUNTIF: Count Cells That Contain TextYes. In Google Sheets, use COUNTIF with asterisks around the text to count cells that contain it anywhere:…
- Schedule Email in Outlook: Send It LaterTo schedule an email in Outlook, write your message, open the menu beside Send, choose Schedule send, and…
- SUMIF Negative Numbers in Google Sheets: Syntax & ExamplesTo sum values that are negative in Google Sheets, use =SUMIF(A2:A100,"<0",B2:B100). This example checks A2:A100 for numbers below…
- How to Double Space in Word Desktop and Format TextTo double-space text in Word desktop, select the text, then choose Home > Line and Paragraph Spacing >…
- Excel Freezing Up and Not Responding? What to Do NowIf Excel is freezing or showing “Not Responding,” first wait briefly if it may be calculating or loading…
- How to Exit Group Edit Mode in Excel and Ungroup SheetsTo exit group edit mode in Excel, click a worksheet tab that is not selected, or right-click a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.