Excel Extend Number Sequence: Fill Series and Formulas

To extend a number sequence in Excel, enter its first two values, select both cells, then drag the fill handle—the small square at the selection’s lower-right corner—down or across. Excel recognizes the interval and continues the pattern; for a custom increment, use Home > Fill > Series or enter a formula that adds the increment to the previous value.

Choose the method that fits your sequence

The quickest approach depends on whether your pattern is simple, predictable, or generated for a specific range. Excel’s fill feature is convenient for a short list, while a formula is easier to inspect and adjust when the sequence depends on a value elsewhere in the worksheet. In Microsoft 365 and Excel 2021 or later, the SEQUENCE function can generate a whole list from one formula.

Use the fill handle for familiar patterns such as 1, 2, 3 or 10, 20, 30.
Use Fill Series to specify an exact step, stop value, or date interval.
Use a copied formula when each result should depend on the cell above it.
Use SEQUENCE when you want a defined number of rows or columns to spill automatically.

Before filling, decide whether the numbers should be fixed values or formulas. Filled values remain as numbers. Copied formulas recalculate if their inputs change, which can be useful in a working model but unexpected in a finished list.

Extend a sequence with the fill handle

For an arithmetic sequence—one that changes by the same amount each time—give Excel two starting values. For example, type 4 in A1 and 7 in A2. Select A1:A2, point at the lower-right corner of the selection until the pointer becomes a small black plus sign, and drag down. The next values are 10, 13, 16, and so on, because the interval is 3.

Enter at least two values that show the intended pattern.
Select the starting cells, including both values.
Drag the fill handle in the direction you want to extend the list.
Release at the last cell to fill. Check the first few results to confirm the interval.

If you select only one number and drag, Excel may copy that number rather than infer an increment. The exact behavior can depend on the type of value and the drag action. Starting with two examples removes ambiguity: 2 and 4 suggests counting by twos, while 2 and 5 suggests counting by threes.

After dragging, Excel may show an Auto Fill Options button near the filled range. Use it to choose whether to continue the series or copy the original cells. This is helpful when Excel’s automatic choice is not what you intended.

Set an exact increment with Fill Series

Fill Series is useful when you know the interval and want to control the end of the sequence. Enter the first value, select the destination range, and choose Home > Fill > Series. In the Series dialog, choose Rows or Columns to match the direction of the list, then select Linear for a constant step. Enter a Step value and, if useful, a Stop value. For a list in a column, choose Columns.

For example, to create 5, 12, 19, 26, and 33, enter 5 in A1, select A1:A5, open the Series dialog, choose Columns and Linear, and set Step value to 7. Excel fills the selected cells with those five values. If you provide a stop value instead of selecting a fixed range, Excel can continue the series until it reaches the stopping point; the result may not land exactly on that value if the step does not divide the distance evenly.

The dialog also offers a Growth option for multiplying by a constant factor rather than adding one. For example, a growth series starting at 3 with a step value of 2 produces 3, 6, 12, 24. Use this for geometric patterns, not for a sequence that increases by a fixed number. The dialog’s Date option can fill dates by day, weekday, month, or year, which is often clearer than trying to infer a calendar pattern from numeric-looking date cells.

Use formulas for a repeatable sequence

A formula is a good choice when you want every row to calculate from the preceding row. With the starting number 12 in A1, enter this in A2, then copy it down:

With 12 in A1 and the next sequence value to be calculated in A2, use =A1+1. The formula returns 13 in A2; copying it to A3 returns 14, and copying it to A4 returns 15.

To count by a different amount, replace 1 with the desired increment. With 12 in A1 and a step of 5, enter =A1+5 in A2. It returns 17; copying down produces 22, 27, and subsequent values. Because the reference A1 is relative, Excel adjusts it to A2 when the formula is copied into A3.

To fill a selected range with a formula, enter the formula in the first destination cell and use the fill handle, or select the range and use Home > Fill > Down. On Windows, Ctrl+D fills the selected cells with the contents of the top cell. In Excel for Mac, Control+D is the corresponding Fill Down shortcut. If the selected range has several columns, fill down applies each column’s top cell to the cells beneath it.

Generate a list with SEQUENCE

SEQUENCE creates a rectangular array of consecutive numbers from a single formula. It is available in Microsoft 365 and Excel 2021 or later. With the formula entered in A1, this example creates ten numbers in one column, beginning at 1 and increasing by 1:

With an empty output area starting at A1, enter =SEQUENCE(10,1,1,1). The formula spills the values 1 through 10 into A1:A10. The arguments specify 10 rows, 1 column, a starting value of 1, and a step of 1.

To make ten values across one row, change the row and column counts. With the output area beginning at A1 and the cells to its right empty, =SEQUENCE(1,10,5,5) returns 5, 10, 15, 20, 25, 30, 35, 40, 45, and 50 across A1:J1. SEQUENCE can also start below zero or use a negative step; for example, starting at 10 with a step of -2 counts down by twos.

A spilled result needs clear cells in the space where the array will appear. If any destination cell is occupied, Excel displays a spill error rather than overwriting that content. Clear or move the obstructing cells, or choose a different starting cell. To turn the generated results into fixed numbers, copy the spilled range and use Paste Special > Values.

Extend dates and other patterns

Excel can recognize more than ordinary counting. Enter two dates to establish a daily interval, or use Fill Series and select a date unit when you specifically need weekdays, months, or years. For example, entering January 1 and January 2 and dragging usually continues by day. If you want the same day of each month, a month-based fill is more suitable than dragging those two daily dates.

Other predictable patterns can also be inferred when you supply enough examples. Enter Monday and Tuesday, for instance, then drag to continue a weekday list. For numbered labels, enter two examples such as Item 1 and Item 2, select both, and try the fill handle. If Excel copies the text instead of extending the number, use a formula or enter additional examples to make the intended pattern clearer.

When a number appears to be part of a label, Excel may treat the cell as text rather than as a numeric value. This can affect how it fills. Check the cell’s contents and number format, and test the fill on a few rows before extending a long range. If a number must keep leading zeros, such as 007, decide whether it is an identifier rather than a quantity: identifiers are often best stored as text or displayed with a custom number format.

Common problems and how to fix them

The same number repeats: Select two or more cells showing the intended increment, then drag again. Alternatively, choose the series option in Auto Fill Options or specify a step in the Series dialog.
The sequence stops too early: Drag farther, select a larger range before using Fill Series, or check whether a stop value is limiting the result.
The result is a copy, not a series: Use the Auto Fill Options button to switch to Fill Series, or provide two starting values rather than one.
The fill handle is missing: In desktop Excel for Windows, check File > Options > Advanced and make sure Enable fill handle and cell drag-and-drop is selected. Excel for Mac has its own settings layout, so look for the fill-handle option in Excel’s editing preferences.
A SEQUENCE formula shows a spill error: Check that cells in the destination area are empty and that the formula is not blocked by merged cells.

Formatting can also make a correct sequence look wrong. A cell formatted as a date may display a serial number as a calendar date, while a number format can hide decimal places. If the underlying values are unexpected, select a cell and inspect the formula bar; if only the display is unexpected, review the number format.

Excel for Mac and Excel for the web

The fill-handle method works in desktop Excel on Windows and Mac, although preferences and some interface details differ. On Windows, the Series command is available through Home > Fill > Series. On Mac, menu placement and available dialog options can vary by Excel release; use the Home tab’s Fill controls if available, or use the fill handle or a formula as an alternative.

Excel for the web also supports common fill-handle workflows, but its interface and available fill controls may not match the desktop Series dialog exactly. If you need a precise step or a particular date unit and cannot find the control in the web app, open the workbook in desktop Excel. SEQUENCE works in supported Microsoft 365 versions, but the space needed for its spilled output must still be free.

Frequently Asked Questions

How do I make Excel count by 2?
Enter 2 and 4 in adjacent cells, select both, and drag the fill handle. Excel continues 6, 8, 10, and so on. For a different starting value or a guaranteed interval, use Home > Fill > Series and set the step to 2.

Why does Excel copy the same number when I drag?
Excel may interpret a single selected number as something to copy. Enter two values that show the interval and select both before dragging, or use Fill Series to state the step explicitly.

Can Excel extend a sequence automatically when I add rows?
A formula copied into new rows can continue a sequence, but a manually filled list does not necessarily expand by itself when rows are added. For a fixed-size dynamic list, SEQUENCE can spill the requested number of values; for a changing table, use a formula or workflow designed around the table’s changing row count.

Can I create a descending number sequence?
Yes. Enter two descending values, such as 10 and 8, select both, and drag to continue by -2. In Fill Series, set a negative step value. SEQUENCE also accepts a negative step.

How do I extend a sequence without changing the original values?
Start the fill in the cells after the existing values and select the appropriate seed cells and destination range. If you use a formula, copy it into new cells rather than replacing the source values. For a dynamic SEQUENCE array, place the formula in a separate empty area.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.