Fill Handle Custom Patterns in Excel: Step-by-Step

Excel’s fill handle can do far more than copy values down a column. By giving it a custom pattern, you can auto-fill repeating sequences like “Week 1, Week 2,” “A-101, A-103,” or “Red, Blue, Green” without typing each cell. This guide shows you how to teach the fill handle your own patterns, what to do when it guesses wrong, and how to fix common issues.

What You’ll Need

Microsoft Excel (desktop, web, or mobile all support this feature)
A worksheet with at least two adjacent cells where you can type your pattern
A clear idea of the sequence you want to repeat (e.g., every third day, product codes with a step of 5)

Step-by-Step

Type the first two values of your pattern in two adjacent cells, either horizontally or vertically. For example, enter 1 in A1 and 3 in A2 to create a pattern that increases by 2.
Select both cells by clicking and dragging over them. The fill handle is the small square at the bottom-right corner of the selection.
Hover over the fill handle until the cursor changes to a thin black cross (not the white arrow).
Click and drag the fill handle in the direction you want the pattern to extend—down, up, right, or left. Release the mouse button when you reach the last cell you want to fill.
Check the Auto Fill Options button that appears at the bottom-right of the filled range. By default, Excel usually copies the pattern (e.g., 1, 3, 5, 7). If it copied instead of extending, click the button and select Fill Series.
For text-based patterns, type the first two items (e.g., “Mon,” “Wed”) and drag. Excel recognizes many built-in lists (days, months, quarters) and will continue them. For a custom text list you use often, add it to Excel’s Custom Lists (File > Options > Advanced > Edit Custom Lists) so the fill handle remembers it forever.
For patterns with a step larger than 1 (e.g., 10, 20, 30), type the first two numbers, select both, and drag. Excel infers the difference and continues it.
To fill only a specific number of cells, drag the handle to that cell. To fill an entire column, double-click the fill handle when the adjacent column has data—Excel fills down to the last row of that data.
For mixed text and numbers (e.g., “Item-1,” “Item-2”), type the first two entries, select them, and drag. Excel keeps the text constant and increments the number.
To create a repeating cycle (e.g., Red, Blue, Green, Red, Blue, Green), type all three values in three cells, select them, and drag. Excel repeats the entire block.

Common Mistakes

Selecting only one cell before dragging. With a single cell, Excel copies the value rather than extending a pattern. Always select at least two cells that define the step.
Dragging the wrong direction. The fill handle extends the pattern in the direction you drag, so dragging up from a selection starting at row 1 will overwrite cells above (which may be headers).
Ignoring the Auto Fill Options button. If the result looks wrong, that button lets you switch between Copy Cells, Fill Series, Fill Formatting Only, and Fill Without Formatting.
Using inconsistent formatting. If your first two cells have different number formats (one text, one number), Excel may not recognize the numeric pattern. Make sure both cells are formatted the same.
Typing dates with different formats (e.g., “1/1/2025” and “Jan 3, 2025”). Excel may not see a consistent step. Use the same date format for both cells.

Tips

Use the right-click drag. Instead of left-clicking, drag with the right mouse button. When you release, a menu appears with options like Fill Series, Fill Months, Fill Weekdays, and Linear Trend. This gives you more control.
For a linear trend with a specific step, type the first two values, then right-click drag and choose Linear Trend. Excel calculates the best-fit line through your two points and extends it.
For growth patterns (multiplying by a constant), type two values (e.g., 2 and 4), right-click drag, and choose Growth Trend. Excel will continue 8, 16, 32.
Add your own custom lists for things like team names, product categories, or office locations. Go to File > Options > Advanced > Edit Custom Lists, type your list in the box (one item per line), and click Add. Then typing the first item and dragging will fill the rest.
Double-click the fill handle to fill down to the last row of data in the adjacent column. This is a huge time-saver for long columns.
Hold Ctrl while dragging to toggle between copying and filling. If Excel is copying when you want a series, hold Ctrl and drag again—it will switch.

Troubleshooting

Excel copies the same value instead of extending the pattern: Select both cells again, then either hold Ctrl while dragging, or after dragging, click the Auto Fill Options button and choose “Fill Series.”
The pattern skips numbers or dates incorrectly: Check that the two starting cells are exactly what you want the step to be. For example, if you want every 5th day, type Jan 1 and Jan 6, not Jan 1 and Jan 2.
Text patterns don’t continue: Excel only auto-fills text patterns it knows (days, months) or ones you’ve added to Custom Lists. If your text isn’t recognized, type the first three or four items, select them all, and drag—Excel will repeat the block.
The fill handle is not visible: Go to File > Options > Advanced and check the box “Enable fill handle and cell drag-and-drop.” If it’s unchecked, the handle won’t appear.
Dragging overwrites existing data: Excel will warn you before overwriting. If you didn’t see a warning, check your settings (File > Options > Advanced > “Alert before overwriting cells”). To avoid the issue entirely, drag into empty cells or insert new rows/columns first.
Dates fill by day but you want weekdays only: After dragging, click the Auto Fill Options button and choose “Fill Weekdays.” Alternatively, right-click drag and select “Fill Weekdays” from the menu.

Frequently Asked Questions

Q: How do I make the fill handle skip weekends?
A: Type the first two weekday dates (e.g., Monday and Tuesday), select them, and drag. Then click the Auto Fill Options button and choose “Fill Weekdays.” Excel will skip Saturday and Sunday.

Q: Can I use the fill handle to create a pattern like 1, 3, 6, 10 (triangular numbers)?
A: Yes. Type the first two values (1 and 3), select them, and drag. Excel will continue the linear step (2, then 3, then 4) only if you use the right-click drag and choose “Linear Trend.” For true triangular numbers, you’d need a formula, but the fill handle can approximate an increasing step if you type the first three values (1, 3, 6) and drag—Excel will repeat the differences (2, 3, 2, 3) rather than continue them.

Q: Why does my fill handle show a small square instead of a cross?
A: That means the handle is disabled. Go to File > Options > Advanced and check “Enable fill handle and cell drag-and-drop.”

Q: How do I stop the fill handle from changing my formatting?
A: After dragging, click the Auto Fill Options button and choose “Fill Without Formatting.” This keeps the pattern but copies the formatting from the destination cells.

Q: Can I use the fill handle to repeat a pattern like A, B, C, A, B, C?
A: Yes. Type A, B, C in three cells, select all three, and drag. Excel will repeat the entire block as long as the cells are formatted as text (or you type letters, which Excel treats as text).

Q: What’s the difference between “Fill Series” and “Linear Trend”?
A: “Fill Series” continues the exact difference between your first two cells. “Linear Trend” fits a straight line through all selected cells (if you select more than two) and extends it. For two cells, they give the same result.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →