The Fill Handle in Excel: Drag, Double-Click, Fill Series
By ExcelReady TeamUpdated 5 min read
The short answer
The fill handle is the small square at the bottom-right corner of the selected cell. Drag it to copy a formula or continue a series such as Jan, Feb, Mar or 1, 2, 3. Double-click it to fill a formula down to the end of the data next to it. Auto Fill Options then switches between copying and a series.
Key takeaways
- The fill handle is the small square at the bottom-right corner of a selection; the pointer becomes a thin black cross.
- Double-click it to fill down to the last row of the neighbouring column's data.
- One number copies; two numbers (like 5 and 10) set the step for a series.
- Months, weekdays, dates and text with a number, like Item 1, continue as a series automatically.
- If the handle is missing, turn on Enable fill handle and cell drag-and-drop in Excel's options.
On this page+
The fill handle in Excel is the small square at the bottom-right corner of the selected cell. Drag it and Excel copies your formula down a column or continues a pattern, such as months, dates or numbers. Double-click it and Excel fills a whole column in one go. This guide shows each way to use the fill handle, how to control what it fills, and how to fix it when it's missing or stops early.
What is the fill handle?#
When you select a cell or range, a small square appears at its bottom-right corner. That's the fill handle. Point at it and the mouse pointer changes from a thick white cross to a thin black cross. That's your sign that you can drag.
The fill handle does two different jobs:
| You start with | Dragging the fill handle |
|---|---|
| A formula | Copies it, adjusting the cell references |
| A number, like 100 | Copies it: 100, 100, 100 |
| Two numbers, like 5 and 10 | Continues the series: 15, 20, 25 |
| A month or weekday, like Jan or Mon | Continues it: Feb, Mar / Tue, Wed |
| A date | Adds one day per row |
| Text with a number, like Item 1 | Continues it: Item 2, Item 3 |
| Plain text, like East | Copies it |
How to copy a formula with the fill handle#
The most common use is copying a formula down a column. Here, each rep needs a total:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Q1 | Q2 | Q3 | Total |
| 2 | Ana | 120 | 140 | 135 | |
| 3 | Ben | 95 | 110 | 105 | |
| 4 | Chloe | 150 | 145 | 160 |
- In E2, type
=SUM(B2:D2)and press Enter. The result is 395. - Click E2 again.
- Point at the fill handle and drag down to E4.
Excel copies the formula and adjusts it for each row: E3 becomes =SUM(B3:D3) (310) and E4 becomes =SUM(B4:D4) (455). These are called relative references. If part of the formula must not move, such as a tax rate in one cell, lock it with $, as in $G$1.
You can drag to the right as well, or up and left. The keyboard alternative is to select the range and press Ctrl+D (Mac: ⌘D) to fill down, or Ctrl+R (Mac: ⌘R) to fill right. The guide to fill down and fill right covers those shortcuts.
How to double-click the fill handle#
Dragging is slow on a long list. Instead, double-click the fill handle. Excel fills the formula down as far as the column next to it has data.
In the example, click E2 and double-click the fill handle. Excel looks at column D, sees data down to row 4, and fills E2:E4 in one go. On a list of 5,000 rows, this saves a lot of scrolling.
Double-click stops at the first empty cell in the neighbouring column. If row 300 is blank in column D, the fill stops at row 299. Check the last row after a double-click, or fill the gaps first; see how to fill blank cells.
How to fill a series of numbers, dates and months#
The fill handle continues patterns it recognises:
- Numbers: type the first two values so Excel knows the step. 1 and 2 gives 3, 4, 5. 10 and 20 gives 30, 40, 50.
- Months and weekdays: type one, such as January or Mon, and drag.
- Dates: one date fills one day at a time. Two dates a week apart fill weekly.
- Text with a number: Item 1, Week 1 or Q1 continue as Item 2, Week 2, Q2.
With a single number, the fill handle copies instead. On Windows, hold Ctrl while dragging to switch between copying and filling a series. On any system, use the Auto Fill Options button described below.
For full control, use Home > Fill > Series. You can set the step value, a stop value, and whether to fill by day, weekday, month or year. The guide to AutoFill series has more examples, including your own custom lists.
How to use the Auto Fill Options button#
After you fill, a small Auto Fill Options button appears at the bottom-right of the filled range. Click it to change what the fill did:
| Option | What it does |
|---|---|
| Copy Cells | Repeats the original values exactly |
| Fill Series | Continues the pattern instead |
| Fill Formatting Only | Copies the format, not the values |
| Fill Without Formatting | Copies values or formulas but keeps the target's format |
| Fill Weekdays / Months / Years | For dates: skips weekends, or steps by month or year |
| Flash Fill | Fills by example from a pattern you typed |
Fill Without Formatting is useful when a formula sits in a striped table: you get the formula without wrecking the row colours. On Windows, dragging with the right mouse button opens a menu with the same choices when you let go.
Fill handle vs Flash Fill#
The fill handle copies or extends what's already in the cells. Flash Fill is different: it learns a pattern from an example you type, such as first names pulled out of full names, and fills the rest. Press Ctrl+E on Windows to use it. On a Mac, or if you prefer the ribbon, use Data > Flash Fill.
The Flash Fill guide explains how it works, and Flash Fill vs formulas helps you choose. Unlike a formula filled with the fill handle, Flash Fill results don't update when the source changes.
Fill handle not working? Quick fixes#
If you can't see or drag the fill handle:
- The option is off. On Windows, go to File > Options > Advanced and tick Enable fill handle and cell drag-and-drop. On a Mac, look under Excel > Preferences > Edit.
- You're editing a cell. Press Enter or Esc first; the handle doesn't show in edit mode.
- The sheet is protected, or the selection includes merged or locked cells.
- Formulas filled but show the same result. Calculation may be set to Manual. Go to Formulas > Calculation Options > Automatic.
- In an Excel table, you often don't need the fill handle: a formula typed in one row fills the whole column by itself.
Practise it#
Practise fill down and fill right in a live spreadsheet: you'll copy formulas down columns and across rows with the fill handle and the keyboard, and each result is checked instantly. Start with the row total exercise on this page.
Try it yourself
This is a live spreadsheet. Type the formula in the green cell and press Enter.
Click E2 and add up Ana's three quarters with =SUM(B2:D2). In Excel, you'd then double-click the fill handle to copy it down for every rep. Press Enter.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Total | |||||
| 2 | ||||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 |
Tip: SUM the three quarter cells in Ana's row.
Practise this in a lesson
Frequently asked questions
Where is the fill handle in Excel?
It's the small square at the bottom-right corner of the selected cell or range. When you point at it, the mouse pointer changes to a thin black cross, and you can drag it.
Why does double-clicking the fill handle stop early?
Double-click fills down as far as the column next to it has data. If that column has an empty cell, the fill stops there. Fill the gap or drag the handle instead.
How do I fill numbers 1, 2, 3 with the fill handle?
Type 1 and 2 in two cells, select both and drag the fill handle. Excel continues the step of 1. With a single cell, drag and then choose Fill Series from the Auto Fill Options button.
Why is the fill handle not showing in Excel?
The option may be turned off. On Windows, go to File, Options, Advanced and tick Enable fill handle and cell drag-and-drop. On a Mac, look in Excel, Preferences, Edit.