How to Paste Down a Column in Excel

How-to basics · Updated November 21, 2026

To repeat the top cell down a column in Excel, select the source cell and the cells below it, then press Ctrl+D on Windows. Or choose Home > Fill > Down. To paste a copied list of different entries, copy the list, select the first destination cell, and press Ctrl+V. These methods work in Microsoft Excel for Microsoft 365 on Windows; the steps below explain when to use each one.

What You’ll Need

  • An Excel workbook with the source value, formula, or copied data you want to place in a column.
  • A clear idea of the destination range: the first cell where the data should go and the last row it should reach.
  • If you are pasting copied data, copy the source first with Ctrl+C. For a fill-down operation, you do not need to copy anything to the clipboard.

Save your workbook before making a large change, especially if the destination column already contains information. Excel can replace existing contents when you paste or fill over them. If you are unsure what is in the target cells, make a copy of the worksheet or workbook first.

Step-by-Step

  1. Decide whether you need to repeat data or paste a list. Use Fill Down when the same value or formula should be repeated from the first selected cell into the cells below. Use ordinary Paste when you have copied a range containing separate entries, such as a list of names, and want those entries to appear in the same order down a column. This distinction matters: Fill Down repeats the first cell; it does not distribute a copied list of different values.
  2. Check the source and destination cells. Click the source cell and confirm it contains the value, text, or formula you intend to use. Identify the final row to fill. For example, if the source is A2 and the destination should run through A12, the full range is A2:A12. Check that no data you need to keep is already in the destination cells, because filling or pasting over them replaces their contents.
  3. Fill the same value or formula down. Select the source cell and all the cells beneath it that should receive the fill. In the example, select A2:A12. Press Ctrl+D. Excel takes the contents of the top cell in the selection and fills the remaining selected cells below it. Include the source cell in the selection; selecting only A3:A12 would make A3 the source instead.
  4. Use the ribbon if you prefer not to use a shortcut. With the source and destination cells selected, go to Home > Fill > Down. This performs the same fill-down action as Ctrl+D. The command is in the Editing group on the Home tab in Excel for Microsoft 365 on Windows. If you do not see Fill, widen the Excel window or look for the Editing group’s menu.
  5. Paste a copied list of different entries. Select the cells containing the list and press Ctrl+C. Click the first cell in the destination column, such as D2, and press Ctrl+V. Excel pastes the copied cells starting there, preserving their relative arrangement. If the copied range has ten rows, it will normally occupy ten destination rows. You usually do not need to select all ten destination cells first; selecting the starting cell avoids a size mismatch.
  6. Check the result before continuing. Look at the first, middle, and last destination cells. Confirm the values appear in the intended order and that nothing important was overwritten. If the source is a formula, click a filled cell and inspect the formula bar to make sure its references are appropriate. If the result is wrong, press Ctrl+Z right away to undo the fill or paste, then repeat with the correct range.

On a Mac, the ribbon command is also available through Home > Fill > Down. In many current versions of Excel for Mac, Control+D performs Fill Down; use the ribbon if that shortcut does not work in your version or conflicts with a system setting. For copying and pasting on Mac, use Command+C and Command+V rather than the Windows Ctrl+C and Ctrl+V shortcuts. In Excel for the web, use the Home tab’s Fill command if a keyboard shortcut is intercepted by your browser.

Fill Down copies more than just a displayed number. It fills the selected cells with the top cell’s contents and formatting. For formulas, Excel normally adjusts relative references as it fills downward. For instance, if B2 contains a formula referring to A2, the filled formula in B3 will generally refer to A3. Absolute references marked with dollar signs, such as $A$2, stay fixed. Review the formulas when the reference behavior matters, particularly before using the results in a report.

Common Mistakes

  • Selecting the wrong starting cell. Fill Down uses the top cell of the selected range as its source. If you select A3:A12 when the intended source is A2, Excel fills from A3 instead. Select the source and the cells to fill as one continuous range.
  • Using Fill Down for a list that should stay different. If you want to paste names, dates, or other distinct entries, use Ctrl+V on the first destination cell. Ctrl+D repeats the top selected cell; it will not paste each copied row as a separate item.
  • Expecting a sequence from one value. Filling 1 down a range repeats 1; it does not automatically create 1, 2, 3, and so on. To extend a sequence, enter enough starting values for Excel to identify the pattern, select those cells and the cells to extend, then use Home > Fill > Series, or drag the fill handle and choose an appropriate series option when available.
  • Overwriting existing data. A paste or fill replaces contents in the cells it reaches. Before acting, inspect the destination column and confirm the selected range ends at the correct row. If the selection is larger than intended, press Esc before filling or pasting, then select the range again.
  • Missing changes caused by formulas or formats. A cell can display the same rounded number as another while holding a different underlying value or formula. Fill Down also carries formatting from the source. Check the formula bar and number format if results look alike but behave differently, or if the filled cells unexpectedly change appearance.

Tips

  • Use the Name Box to select a long range precisely. The Name Box is to the left of the formula bar. Type a range such as A2:A500 and press Enter to select it, then use Ctrl+D. This is often quicker and more accurate than dragging through hundreds of rows.
  • Fill a formula without copying its formatting. Fill Down carries the source cell’s formatting as well as its contents. If the appearance of the destination cells must remain unchanged, use the fill first, then use the Auto Fill Options button if it appears and select Fill Without Formatting. Another approach is to copy the source, select the target range, and use Paste Special to choose the content you need; check the available options in your Excel version.
  • Use the fill handle for a small range. Select the source cell and point to the small square at the lower-right corner of its selection border. Drag the fill handle down to the last row. This is convenient for a short range, but Ctrl+D or the ribbon command is usually easier to control for a large range.
  • Know how formulas adjust. A relative reference such as A2 changes as a formula is filled down, while an absolute reference such as $A$2 remains fixed. Mixed references such as A$2 lock the row but not the column. If every filled formula should use one fixed cell, verify that the reference is absolute before filling.
  • Keep a clear boundary around the data. If you want to fill only through the last record, use a deliberate range rather than selecting the whole column. A whole-column operation can be slow or affect cells far below the visible data. A range like C2:C250 makes the intended extent easier to verify.

Troubleshooting

Ctrl+D does nothing or triggers another action. First confirm that Excel is the active window and that at least two cells, including a source cell at the top, are selected. Try Home > Fill > Down to bypass a shortcut issue. On a Mac or in a browser, shortcut handling can differ; use the ribbon command instead.

The wrong value was repeated. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Select the intended source cell together with the destination cells, making sure the source is at the top, and run Fill Down again. If you wanted separate copied values, recopy the complete list and paste at the first destination cell instead.

Formulas show the wrong results after filling. Click one of the affected cells and inspect its formula in the formula bar. Relative references shift when copied down, which is often helpful but may not be what you need. Edit the source formula to use the appropriate absolute or mixed references, then refill the range. Also check for blank cells, text stored as numbers, or calculation settings if the displayed results do not update as expected.

The pasted range does not fit or data is missing. Confirm that you copied the entire source range, not just one cell, and that the destination begins at the intended row. If Excel reports that the copy and destination areas are different sizes, press Esc, click only the top-left destination cell, and paste again. If the source is laid out across a row but the destination needs a column, use Paste Special > Transpose rather than an ordinary paste; the exact menu presentation can vary by Excel version.

Some cells refuse to fill or the selection is unusual. Merged cells, protected worksheets, filtered lists, or noncontiguous selections can interfere with a fill. Check whether the sheet is protected and whether the source or destination contains merged cells. If a filter is active, review which rows are visible and hidden before changing data; do not assume a fill affects only the visible records. Try an ordinary, unfiltered range on an unprotected sheet to isolate the cause.

Frequently Asked Questions

Does Ctrl+D paste or fill down in Excel?
Ctrl+D is the Fill Down shortcut in Excel for Windows. It copies the top cell’s contents and formatting into the selected cells below it. It is not the same as pasting a copied multirow list with Ctrl+V.

Can I fill a blank cell with the value above it?
Yes. Select a range that starts with the cell containing the value and continues through the blank cells, then use Ctrl+D or Home > Fill > Down. The top cell must contain the value you want repeated.

How do I paste without changing the destination formatting?
After copying, use Paste Special and choose Values when you want the copied results without the source formatting or formulas. In Excel for Microsoft 365 on Windows, open Home > Paste > Paste Special and select Values. The available options and shortcut presentation may vary slightly by platform.

How do I paste a row of copied cells into a column?
Copy the row, select the destination cell, and use Paste Special > Transpose. This changes the orientation so the copied row becomes a column. Check the result before replacing any existing data in the destination area.

Can I fill down only to the last used row?
Yes. Select from the source cell through the final row you intend to fill, using the Name Box for a long range if needed, and run Fill Down. Check the last row in the selection before using the command so you do not extend data too far.

Related

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.