To copy a cell down a column in Excel, select the cell and the cells below it, then press Ctrl+D on Windows. You can also drag the fill handle at the lower-right corner of the selected cell, or copy and paste into a chosen range. These methods can copy values, formulas, and formatting; the best choice depends on whether you want a quick fill or more control over what gets copied.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows.
- A source cell containing the value, formula, or formatting you want to copy.
- A destination range in the same column. If the destination cells already contain information, check that it is safe to replace it before filling.
You do not need to turn on a special setting for the basic methods. If your workbook is important, save it before making a large change so you can recover the original if you overwrite the wrong cells.
Step-by-Step
-
Choose what you want to copy. Click the cell that contains the value, formula, or format you want repeated. If you want to copy a formula, click its cell and check the formula bar so you know which references it uses. For example, a formula in C2 might refer to A2 and B2. When copied down, relative references usually adjust for each row; that is often what you want when each row contains a different record.
-
Select the destination cells. Include the source cell at the top of the selection, then extend the selection down through the last cell you want to fill. For example, to copy A2 through A10, click A2 and drag down to A10, or click the Name Box to the left of the formula bar, type A2:A10, and press Enter. The source must be the top cell in the selected range for Fill Down to work as intended.
-
Use Fill Down for a fast, exact copy. With the source and destination range selected, press Ctrl+D. Excel copies the top cell down into the other selected cells. Alternatively, on the ribbon choose Home > Fill > Down. This method is useful when you know the exact range and want to fill it without dragging. On Excel for Mac, the corresponding shortcut is Command+D; the ribbon route is also available.
-
Or drag the fill handle. Select the source cell and move the pointer to the small square at its lower-right corner. When the pointer changes to a thin black plus sign, drag the handle down to the last destination cell, then release. Excel fills the cells with the source content. This is convenient for a short range that is visible on screen. If you drag too far or stop too soon, use Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then try again.
-
Use double-click to fill beside a data list. If the column next to your destination has a continuous list of entries, select the source cell and double-click its fill handle. Excel usually fills down alongside that neighboring list. For instance, if column A has names through row 80 and you want to copy a formula in B2, double-clicking B2’s fill handle can extend the formula down beside the names. This shortcut depends on adjacent data: blank gaps or an empty neighboring column can make Excel stop early or have no clear stopping point.
-
Use copy and paste when you need more control. Select the source cell and press Ctrl+C, select the destination range, and press Ctrl+V. You can paste into a single cell or a range. To paste only values, use Home > Paste > Paste Values after copying. This is helpful when you want the displayed results rather than formulas, or when you do not want the source cell’s formatting to replace the destination formatting. On Mac, use Command+C and Command+V, then choose the appropriate paste option from the ribbon or context menu.
-
Check the result before continuing. Click a few cells near the top, middle, and bottom of the filled range. Confirm that values, formulas, and formatting are what you intended. For formulas, inspect the formula bar in at least one destination cell to see whether the references adjusted correctly. If the fill repeated a number when you expected a sequence, or changed a formula reference you meant to keep fixed, undo and select a different fill method or correct the references before filling again.
Common Mistakes
Selecting only the destination cells: Ctrl+D uses the top cell in the selected range as its source. If the source cell is not included at the top, Excel may fill from the wrong cell or leave you with an unexpected result. Select from the source down through the final destination cell.
Dragging the wrong square: The fill handle is the tiny square at the bottom-right of the active cell outline, not the larger border around the cell. If the pointer is not over the handle, dragging may select cells or move content rather than fill. Wait for the thin black plus sign before dragging.
Overwriting data without noticing: Fill Down, dragging, and paste replace content in destination cells. Check the selected range and any existing entries before you apply the fill. If you overwrite something, use Undo before making other edits.
Assuming formulas copy as fixed text: Excel normally adjusts relative references as a formula moves. A reference such as A2 can become A3 in the next row. If a reference should stay on the same cell, use an absolute reference such as $A$2 in the original formula. Mixed references, such as A$2, lock only the row.
Confusing copying with creating a series: A copied cell repeats its content, while a fill operation may sometimes continue a recognizable pattern. If Excel extends numbers or dates when you wanted duplicates, check the Auto Fill Options button that appears after dragging and choose Copy Cells. Alternatively, use Ctrl+D or copy and paste for a direct repeat.
Tips
For a long column, selecting the range by its address is often more dependable than dragging through hundreds of rows. Use the Name Box to enter a range such as D2:D500, then choose Home > Fill > Down. Remember that the first cell in that range supplies the content for the cells underneath it. If you need to fill from D1 instead, include D1 in the range.
When working with formulas, decide whether each reference should move before you fill. Relative references change as the formula is copied; absolute references marked with dollar signs stay fixed. For example, if a formula should always use a tax rate stored in F1 while using a different row’s price, lock the tax-rate reference in the original formula before filling. You can toggle reference types while editing a formula by selecting a reference and pressing F4 on Windows; on some laptops, you may need Fn+F4. Mac keyboard behavior can depend on the keyboard settings, so you can also type the dollar signs directly.
To repeat content but preserve the destination cells’ appearance, use Paste Values when the source is a formula or use the paste options that match your goal. To copy formatting only, use the Format Painter on the Home tab rather than filling the cell’s content. If you want both the content and formatting, ordinary copy and paste is usually the straightforward choice.
For a quick fill in a structured list, double-clicking the fill handle can save time, but only when neighboring data clearly marks where to stop. For a precise range, Ctrl+D is more predictable. If you are unsure which method is safest, fill a few rows first, inspect them, and then complete the remaining range.
Troubleshooting
Ctrl+D does nothing or fills the wrong cells: Check that the active selection contains at least two cells and that its top cell is the intended source. Make sure the cells form a vertical range in one column. You can also use Home > Fill > Down to confirm you are choosing the same operation.
The fill handle is missing: Excel may have the fill handle turned off. On Windows, open File > Options > Advanced. Under Editing options, make sure Enable fill handle and cell drag-and-drop is selected, then choose OK. If you are using Excel for the web, use the ribbon’s Fill command or copy and paste instead if dragging is unavailable or difficult in your browser.
Double-click stops too soon: Double-click fill uses nearby data to estimate the end of the range. Look for blank rows or gaps in the adjacent column. If the neighboring list is incomplete, select the full destination range yourself and use Ctrl+D or drag the handle to the exact row.
Formulas show the wrong results: Click a filled cell and compare its formula with the source. If a reference that should stay fixed has shifted, edit the original formula to use dollar signs for that reference, then fill again. If you only wanted the calculated results, undo the fill and paste values instead. Also check whether a formula refers to blank cells or data in a different row than expected.
Numbers or dates formed a pattern instead of repeating: If you dragged the fill handle, click the Auto Fill Options button near the filled range and choose Copy Cells. If the button is no longer visible, undo and use Ctrl+D or copy and paste to repeat the source exactly.
Frequently Asked Questions
What is the quickest way to copy a cell down a column?
Select the source cell and all the cells below it that you want to fill, then press Ctrl+D on Windows. On Mac, use Command+D. The source cell must be at the top of the selected range.
Can I copy a formula down without changing its references?
Yes. Make the references you want to keep fixed absolute by adding dollar signs, such as $A$1, before copying. If you want the formula’s results but not formulas in the destination cells, use Paste Values instead.
How do I copy a cell down to the last row of nearby data?
Select the source cell and double-click its fill handle. Excel uses the adjacent data to estimate how far to fill. If there are blank gaps or the neighboring list ends early, select the destination range manually instead.
How do I copy the value but not the formatting?
Copy the source, select the destination, and choose Home > Paste > Paste Values. This pastes the value or formula result without bringing over the source cell’s formatting.
Why does Excel create a number or date sequence?
When you drag the fill handle, Excel may infer that you want to continue a pattern. Use the Auto Fill Options button and choose Copy Cells, or use Ctrl+D or copy and paste when you want the same entry repeated.
Does this work in Excel for the web?
Yes. You can select a vertical range and use the Fill command on the Home tab, or copy and paste. Keyboard shortcuts can vary with the browser and operating system, so the ribbon is a reliable alternative if a shortcut does not behave as expected.
Related
- How to Color Every Other Row in Excel Automatically
- Color Code Data Validation in Excel with Conditional Rules
- Excel Screen Lock: How to Unlock a Sheet or Unfreeze Panes
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: Count Cells With a Specific Dropdown ValueTo count cells that contain a particular Google Sheets dropdown choice, use COUNTIF. For example, if dropdowns are…
- Outlook Webmail View: Change Layout and Reading PaneTo change your view in Outlook webmail, open Settings (the gear icon), go to Mail > Layout, and…
- Excel Solver Settings: How to Set Up and Choose OptionsIn Excel for Microsoft 365 on Windows, open Data > Solver, set an objective cell, choose the cells…
- Excel Table Row Number: Get the Position or Sheet RowIn Excel, a table row can mean either its position within the table or its actual worksheet row…
- How to Create a Header Template in WordTo create a reusable header template in Word, design the header in a document, then save the file…
- Create a Slicer in Excel: Setup, Filtering, and TipsTo create a slicer in Excel for Microsoft 365 on Windows, select a cell in an Excel table…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.