AutoFill Excel Dates in Series or Same Date

AutoFill Excel Dates in Series or Same Date

If you’re entering dates on an Excel worksheet, you don’t have to enter each date individually. Just enter the first date, in the top cell. Then, if there is data in the next column, you can use the Fill handle to quickly enter the rest of the dates. See how to AutoFill Excel dates in series or same date, with just a couple of clicks.

Start a Date Series

Enter the first date in the date column — cell A2 in this example. Then point to the Fill handle, which is the small black square at the bottom right corner of the selection.

When the pointer changes to a small black plus sign, double-click.

AutoFillDates01

Dates Series

When you double-click the Fill handle, Excel automatically fills the dates down to the first blank cell in the next column.

By default, the dates are entered in a series of 1 day intervals.

AutoFillDates02

Change to Same Date

If you want all the date cells to have the same date, do one more step:

  • Keep the range of date cells selected (cells A2:A9 in this example)
  • Press Ctrl+D on the keyboard.

That is the keyboard shortcut for Fill Down. When you use that shortcut, Excel copies the date from the active cell (cell A2), into all the selected cells below.

AutoFillDates03

Watch the Video

To see the steps for filling the dates, watch this very short video. The video shows how to create a date series with the Fill handle. Then it shows how to use a keyboard shortcut, to enter the same date in all the selected cells.

I created this with the latest version of Camtasia Studio, which has a new feature that captures keyboard shortcuts, and can show the key combinations in the video.

More Excel Shortcuts

See more Excel keyboard shortcut on my Contextures website. There is an interactive list of shortcuts that you can search and filter. You can also download an Excel workbook with a list of shortcuts.

______