In Excel: select the cells, then grab the small green square at the bottom-right corner — the fill handle — and drag it down or across to copy values or extend a series; double-click it to fill down to the end of the adjacent data.
Enter enough values to define the pattern (one cell to copy, two cells for a series).
Select those cells so the fill handle appears at the bottom-right.
Drag the handle down or across, or double-click it to fill down to the end of the adjacent data.
Click the AutoFill Options button to pick Copy Cells, Fill Series, or Fill Formatting Only.
Use Ctrl+D to fill down or Ctrl+R to fill right without dragging.
What this does
The fill handle is the small green square at the bottom-right corner of a selection. Dragging it copies the selected cells or extends a detected series, and double-clicking it fills down to the bottom of the data in the neighboring column. AutoFill reads the pattern in what you selected — 1, 2, 3… or Jan, Feb… — and continues it. Ctrl+D fills the selection down from the cell above; Ctrl+R fills right. After a drag, the AutoFill Options button appears so you can switch between Copy Cells, Fill Series, and Fill Formatting Only. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “excel auto fill date”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a workflow that saves repeating the same clicks every week, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
Type 1 in A1 and 2 in A2, select both cells, then drag the fill handle down — Excel reads the step of 1 and continues 3, 4, 5… If you instead dragged a single cell containing 1, it would copy 1, 1, 1 until you switch to Fill Series. Dragging the fill handle is the fastest way to repeat a value or build a numbered or dated series down a column without typing each cell. A practical tip before you scale it up: build it once on a small block of test data, confirm the number against the tool on this page, and only then point it at your real sheet. That one habit catches almost every mistake while it is still cheap to fix, long before a wrong figure reaches a report or a colleague.
In Google Sheets
Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. Keep this page bookmarked for the next time the same question comes up. Better still, rebuild the example once in your own sheet — doing it yourself, with the tool above to check against, is what turns a copied formula into a technique you own. If you take one thing from this page on “excel auto fill date”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.
Common mistakes
- Dragging one cell and expecting a series — a single cell copies; give it two cells to set the step.
- Double-clicking the handle when the adjacent column has gaps, so the fill stops early.
- Ignoring the AutoFill Options button when Excel guessed copy instead of series.
- Holding the wrong corner — the move pointer (four arrows) drags the cell, not the fill handle.
Frequently asked questions
Where is the fill handle?
It is the small green square at the bottom-right corner of the selected cell or range.
How do I fill down without dragging?
Select the range and press Ctrl+D to fill down, or Ctrl+R to fill right.
Why does my drag copy instead of counting up?
A single starting cell copies. Enter two values first, or open AutoFill Options and choose Fill Series.
Other ways people ask this
This is also commonly searched as “excel auto fill dates”, “auto date fill in excel”, “how to auto fill dates in excel” and “excel date auto fill”. They describe the identical operation, so you are in the right place no matter how you phrased it.
Why do people search for this in so many different ways?
Because the same task has many names. “excel auto fill dates”, “auto date fill in excel”, “how to auto fill dates in excel” all point at the one operation explained on this page, which is why they all lead here.