Stockertim Dictionary · Technology
Fill handle
Also called fill handles, autofill handle, AutoFill
In short
The small square at the bottom right corner of a selected cell or range that is dragged or double-clicked to copy a formula or extend a series into nearby cells.
- Beginner
- Technology
- Checked
In detail
When a cell is selected, a small square appears at its lower right corner. Dragging it down or across copies the cell's contents into the cells passed over. For a formula, each copy adjusts its relative references to its new position. For a value with a pattern, the program extends the pattern instead: Monday becomes Tuesday and Wednesday, January becomes February, and a selection of 5 and 10 continues as 15, 20 and 25.
Double-clicking the handle fills a formula down automatically as far as the data in the neighbouring column goes. This is the quickest way to apply one formula to thousands of rows, but it depends on that neighbouring column having no gaps: the fill stops at the first blank cell, which can leave the bottom of a table without its formula.
After a fill, a small options button usually appears. It lets the user choose between copying the cells exactly, filling the series, or filling formatting only or values only. Holding a modifier key while dragging can also switch between copying and extending a series, which explains why the same drag sometimes produces 1, 1, 1 and sometimes 1, 2, 3.
The handle is convenient but unforgiving. Filling a formula over cells that already held different formulas overwrites them without warning, and an absolute reference that should have been relative, or the reverse, is copied faithfully into every row. Checking the last few filled rows and the row count against the data catches most problems.
Worked example
A clerk at a school uniform supplier has 1,200 order lines with quantity in B and price in C, and writes =B2*C2 in D2.
- Double-clicking the fill handle on D2 copies the formula to D3 to D1201
- Row 1201 holds 3 items at 15: 3 × 15 = 45
Every order line gets its value in one action, as long as column C has no blank cells partway down.
In practice
Office workers use the fill handle daily to copy row formulas down tables, to number rows, and to lay out month or date headings across a budget. Many teams prefer formatted tables, which fill new rows automatically, for data that keeps growing.
Watch out
- A double-click fill stops at the first gap in the neighbouring column, so check that the last row received the formula.
- Dragging a single number copies it; select two cells with the step you want before dragging to create a series.
Learn it properly
Official sources
Facts last checked on 9 November 2026.
Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.