01 Foundations

The fill handle: Excel's pattern engine

The little green square in the corner of every selection is how one formula becomes a thousand — and how dates, series and patterns write themselves.

16 July 2026 2 min read Eoin Derry

In the bottom-right corner of every selection sits a small green square. Most people discover by accident that dragging it copies the cell — and stop there, having found perhaps a fifth of what it does. That square is the fill handle, and it’s really a pattern engine: show it the start of a pattern and it continues the pattern, for ten rows or a hundred thousand.

Copy-down: how one formula becomes a column

Its first job is the one that makes spreadsheets spreadsheets. Write =B2*C2 in D2, drag the handle down, and every row gets the formula re-aimed at its own row — =B3*C3, =B4*C4 — the relative-reference replay in action. One formula, written once, working everywhere.

Two upgrades on the drag, in the order you’ll come to love them:

• Double-click the handle instead of dragging. The fill runs down as far as the neighbouring column has data — a 50,000-row column filled in the time a drag would cover twenty. This is the single best five-second upgrade in beginner Excel.
• Stop needing it at all. Inside a proper Table, a formula typed in one cell fills its entire column automatically, and new rows inherit it. The fill handle is how you work before Tables; Tables are why you’ll eventually drag less.

Series: the handle can count

Type 1 and drag: you get 1, 1, 1 — a copy. Type 1 and 2, select both, and drag: 3, 4, 5… — a series. Given two cells, the handle infers the step, and it extrapolates anything with a rhythm: 10, 20 → 30, 40; Q1, Q2 → Q3, Q4; Jan → Feb, Mar; Monday → the week; 04/07/2026 → daily dates forever.

One engine, three patterns: steps, sequences and re-aimed formulas. Show it the rhythm; it does the typing.

The steering wheel is the small Auto Fill Options button that appears after every fill — it flips a fill between Copy Cells and Fill Series when Excel guessed the wrong one, and offers Fill Weekdays for dates (a payroll favourite). Right-drag the handle for the same menu up front. And the fill that copies a formula but drags its formatting along, wrecking your borders: Auto Fill Options → Fill Without Formatting. That one button answers about three separate beginner miseries.

The other steering input is the $ sign: a fill re-aims unpinned references and respects pinned ones. If a fill goes wrong, it’s nearly always a pin missing or a pin too many — read the references, not the maths.

Custom rhythms and the modern successors

Excel knows months and weekdays out of the box. Teach it your own sequences — site names, team rota, product tiers — in File → Options → Advanced → Edit Custom Lists, and the handle (and custom sort orders) learn your world.

Two neighbours complete the picture. Flash Fill (Ctrl+E) is the handle’s clever cousin — it imitates transformations by example rather than continuing series; it gets its own lesson with its own warnings. And SEQUENCE is the formula-native way to generate series in modern Excel — =SEQUENCE(12) spills 1 to 12 with nothing dragged, which matters once your sheets start building themselves.

One more habit while you’re here: the handle also clears. Select a filled range, drag the handle upward through it, and the cells empty — tidier than delete-and-repair when trimming a series.

Small square, big share of every working day. Learn the double-click, meet the options button, and let the patterns write themselves — stage one of the path is full of these ten-thousand-times moves, and this is the most literal of them.