Copy the Same Date Down an Excel Column Without Auto-Fill

How-to basics · Updated November 20, 2026

To copy the same date down an Excel column without Excel increasing it, enter the date in the top cell, select that cell and the cells below it, then choose Home > Fill > Down or press Ctrl+D in Excel for Microsoft 365 on Windows. Excel copies the top cell’s contents to the selected cells instead of extending a date series. You can also copy and paste the cell, or enter one date into several selected cells at once.

These methods are useful for repeating a deadline, reporting date, invoice date, or other fixed date in multiple rows. Before starting, decide how many rows should receive the date and check whether the cells contain data you need to keep: Fill Down and paste can overwrite selected cells. If you need the date to change automatically each day, use a different approach, such as the =TODAY() formula, rather than copying a fixed date.

What You’ll Need

  • An Excel workbook open in Microsoft Excel for Microsoft 365 on Windows. The ribbon commands are also available in Excel for Mac and Excel for the web, although keyboard shortcuts may differ or be intercepted by the browser.
  • A starting cell containing the date you want to repeat, plus the destination cells. For example, use A2 for the date and A3:A20 for the cells below it.
  • A clear idea of whether you want to copy the cell’s formatting too. Fill Down copies the top cell’s contents and formatting; Paste Special can copy the date value without changing destination formatting.

Step-by-Step

  1. Enter and check the date in the first cell. Click the first cell in the column, such as A2, and type the date. Use a format that is clear in your regional settings. For example, a date with a spelled-out month, such as 8-Mar-2026, is less likely to be confused with a different month and day order than 3/8/2026. Press Enter to commit it. Click the cell again and check that Excel recognizes it as a date: by default, dates are usually right-aligned, and the formula bar shows the stored date value or its date display. If Excel leaves the entry as text, correct it before filling the column.
  2. Select the source cell and all the destination cells. Click A2, then drag down to the last cell you want to fill, such as A20. The selected range should include both the original date cell and the blank cells below it: A2:A20. You can also click the Name Box to the left of the formula bar, type A2:A20, and press Enter. Replace those addresses with the range you actually need. Including the source cell matters because Fill Down uses the top row of the selection as its source.
  3. Fill the selected range from the top cell. On the ribbon, choose Home > Fill > Down. Excel copies the contents of A2 into the cells below it, so every selected row receives the same date. On Windows, Ctrl+D performs the same Fill Down action. On Excel for Mac, use the ribbon command if you are unsure which shortcut your keyboard configuration supports; keyboard shortcuts can vary with macOS settings. In Excel for the web, use the Home ribbon command if a browser shortcut conflicts with Excel.
  4. Check a few cells at the top and bottom of the range. Click A3 and A20, or the first and last destination cells in your range. The formula bar should show the same date as the source cell. Also check the visible display: Excel might show the same date in a different format if the destination cells have different number formats, although Fill Down normally copies the source formatting too. If the date itself is correct but the display is not, see the troubleshooting section below.

For a small group of cells, copying and pasting is another straightforward option. Select the date cell and press Ctrl+C on Windows, select the destination range, and press Ctrl+V. On Mac, use Command+C and Command+V. This repeats the copied cell contents, but a normal paste can also copy its formatting. If you only need to transfer a date value and want to keep the destination cells’ existing formats, copy the source, select the destination range, then choose Home > Paste > Paste Special > Values. The exact Paste Special choices can vary slightly between Excel versions and platforms.

There is also a way to enter a date into a selected range without copying first. Select all the cells you want to fill, including the first cell, type the date, and press Ctrl+Enter on Windows. Excel puts the entry into every selected cell. On Mac, use Control+Return if that shortcut is available in your Excel version; if not, use Fill Down or copy and paste. This method is handy for a small range, but be careful: typing while multiple cells are selected replaces their existing contents with the new date.

Common Mistakes

  • Dragging the fill handle and getting consecutive dates. Excel often treats a dragged date as the start of a series, so the cells may become March 8, March 9, March 10, and so on. To repeat the original date, use Fill Down or copy and paste. If you have already dragged, use the Auto Fill Options button beside the filled range and choose Copy Cells, if that option appears, or undo the fill and use a reliable method instead.
  • Selecting only the blank destination cells. Fill Down takes its source from the top row of the selected range. If the selection starts at A3 rather than A2, it cannot use A2 as the source. Select A2:A20, not just A3:A20.
  • Overwriting information below the source. Fill Down, paste, and Ctrl+Enter replace existing cell contents within the selected range. Before filling a long column, inspect the range or make a copy of the worksheet. Do not assume that blank-looking cells are truly empty; they may contain formulas, spaces, or data hidden by formatting.
  • Entering a date Excel treats as text. A date such as 31/12/2026 may not be recognized in a workbook using a month/day/year regional format. Excel may align it like text or fail to sort it chronologically. Enter the date in a format your Excel settings recognize, or use the date picker if one is available in your setup, and confirm the value before filling.
  • Confusing a fixed date with a changing date. Copying a date stores the same date in each destination cell; it does not update tomorrow. Conversely, a formula such as =TODAY() recalculates to the current date and is not a permanent record of the date when you entered it. Choose the kind of date that matches your task.

Tips

  • Use Fill Down for a long, contiguous range. Selecting the whole range and using Home > Fill > Down avoids the fill-handle behavior that can create a series. It is also more precise than dragging to estimate the final row.
  • Use the Name Box for a large range. If you need to fill thousands of rows, type a range such as A2:A5000 into the Name Box and press Enter. Then use Fill Down. Check that the range ends at the intended row before applying the command.
  • Preserve destination formatting when needed. If each row has its own formatting, copy the source date and use Paste Special > Values rather than a regular paste. Alternatively, fill first and reapply the desired number format to the destination range afterward.
  • Apply a consistent date display separately. To set the appearance of a range, select it and use Home > Number Format to choose a date format. The display format does not change the underlying date; it changes how the date is shown. For example, one stored date can appear as 8-Mar-2026 or 3/8/2026 depending on the selected format and regional settings.
  • Use a fixed date when records must not change. For a report or log that needs to retain the date entered, type a date value and copy it. A formula based on the current date may recalculate when the workbook opens or recalculates, so it is usually not a substitute for a fixed entry in a historical record.

Troubleshooting

The dates increase by one day instead of repeating. Undo the action with Ctrl+Z on Windows or Command+Z on Mac, then select the source cell together with the destination cells and use Home > Fill > Down. If you prefer dragging, choose Copy Cells in the Auto Fill Options menu after dragging, when available. Do not choose Fill Series.

The cells look different even though they contain the same date. Select one of the cells and look at the formula bar. If the stored date is the same, the difference is probably number formatting, not the date. Select the affected range and apply a consistent date format from Home > Number Format. If you used Paste Special Values, this difference is expected because that action can leave the destination formatting unchanged.

The date will not sort or behave like a date. The original entry may be stored as text. Try selecting the cell and re-entering the date in a format recognized by your regional settings. You can also select the affected cells and check Home > Number Format; changing a format alone does not always convert text into a real date. If the data was imported, use Excel’s text-conversion tools or re-import it with the correct date locale rather than relying on appearance alone.

Fill Down does not copy the date you expected. Check that the selected range begins with the cell containing the date. If the first row is blank, Excel may fill the selected cells with a blank. Also check for merged cells, protected worksheets, or an active filter. Merged cells can restrict filling, and worksheet protection may prevent edits. Unmerge or unprotect the relevant area only if you are authorized to do so, then select a simple, continuous range and try again.

The command is unavailable or the shortcut does something else. Make sure a worksheet range is selected and that the workbook is not in a mode that prevents editing. Use the ribbon path Home > Fill > Down instead of a shortcut. In a browser, keyboard shortcuts may be intercepted by the browser or operating system; the Excel for the web ribbon is a useful alternative. On Mac, use the ribbon when a Windows shortcut does not match your keyboard setup.

Frequently Asked Questions

How do I copy the same date into an entire column?
Select the date cell and the cells below it, then choose Home > Fill > Down. To fill a very large range, enter the full address in the Name Box first. Avoid selecting the entire worksheet column if you only need part of it, because that can overwrite data much farther down than intended.

Why does Excel change the date when I drag the fill handle?
Excel commonly interprets a dragged date as the start of a date series and advances the date in each row. Use Fill Down or copy and paste to repeat the exact value. If you use the fill handle, choose Copy Cells from the Auto Fill Options button rather than a series option.

Will copying a date also copy its formatting?
Fill Down and a regular paste generally copy the source cell’s formatting along with its contents. If you want to keep the destination cells’ existing formatting, copy the source and use Paste Special > Values. The precise menu presentation can differ across desktop, Mac, and web versions of Excel.

Can I put the same date in several cells that are not next to each other?
Yes. Select the cells or ranges you need, type the date, and use Ctrl+Enter on Windows to enter it in all selected cells. On Mac, try Control+Return where supported. Because this replaces the contents of every selected cell, check the selection carefully first. For nonadjacent cells, copy and paste may be easier to control.

How can I enter today’s date without it changing tomorrow?
Enter today’s date as a fixed value, then use Fill Down or paste to repeat it. In Excel for Windows, Ctrl+; inserts the current date as a fixed value in the active cell. On Mac, the shortcut may differ by Excel version and keyboard settings, so typing the date directly is a dependable alternative. The =TODAY() formula is dynamic and can update when Excel recalculates.

Can I repeat the date but show it differently in each cell?
Yes. The cells can store the same date while displaying different formats, such as a short date in one row and a date with the month spelled out in another. Apply the desired number format to each cell or group of cells. Different appearances do not mean the stored date values are different; check the formula bar or set a temporary consistent format to compare them.

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.