How to Fill a Series in Excel (Without Dragging)
You want to continue a sequence down a column, but the fill handle needs a careful mouse drag, guesses the step, and overwrites whatever it crosses. Here's why, and the one-click way that fills only the blanks.
Last updated: August 2026
| Before | After | |
|---|---|---|
| 1, 2, _, _ | → | 1, 2, 3, 4 |
| Item 1, Item 2, _ | → | Item 1, Item 2, Item 3 |
Why the fill handle is fiddly
Excel's fill handle — the little square you drag from the corner of a cell — needs a precise mouse motion down the whole range, and on a long column that means scrolling while you hold the button. It guesses the step from what you selected, so a single value increments by one whether you meant it to or not, and it will overwrite any data it passes over. The SEQUENCE function is 365-only and replaces the cells with a formula rather than filling blanks. It's easy to get wrong or undo by accident.
The 1-click way — Tellsheet's Fill Series
Put the first value or two at the top and select the column, then run Fill Series. It reads the step from your starting values and continues the sequence into the blanks below: numbers and dates extend arithmetically, and text ending in a number carries on — Item 1, Item 2 becomes Item 3. It never overwrites existing data, so it only fills empty cells — no mouse drag, no guessing. Pairs with Add Serial Numbers and Fill Blank Cells.
Frequently asked questions
How do I fill a series without dragging?
Type the first value or two, select the column, and run Fill Series. It continues the sequence into the blanks below in one click — no fill handle needed.
Does it handle dates and text too?
Yes — numbers and dates extend arithmetically, and text ending in a number carries on, so Item 1, Item 2 becomes Item 3, Item 4.
Will it overwrite my data?
No — it only writes into blank cells below your starting values, so existing data is safe.
How does it know the step?
From the first value or two you type: one value steps by one, and two values set the interval, so 5, 10 continues 15, 20.
Related Excel guides
Continue any sequence in one click
Fill Series extends numbers, dates, and text down a column into the blanks — without dragging and without overwriting.
Get Tellsheet free See pricing