Number Sequence in Excel: How to Continue a Series

To continue a number sequence in Excel, enter the first two values, select both cells, then drag the fill handle down or across. Excel detects the difference between them and extends the pattern. For a custom step or a fixed endpoint, use Home > Fill > Series. These methods work in Microsoft Excel for Microsoft 365 on Windows and are useful for numbering rows, making intervals, and extending simple arithmetic sequences.

What You’ll Need

An Excel worksheet with the starting value or values in cells.
A clear idea of the pattern: for example, count by ones, count by fives, or decrease by two each time.
Enough empty cells below or beside your starting values for the sequence. Check that they do not contain information you need to keep, because filling into them can replace their contents.

You do not need an add-in or a special setting. If you want Excel to infer a step, provide two example numbers. If you use just one starting number, Excel may copy it rather than create the sequence you intended.

Step-by-Step

Enter the first number or numbers. Click a cell, such as A1, and type the beginning of the sequence. For a sequence that increases by one, enter 1 in A1 and 2 in A2. For a sequence that increases by five, enter 5 in A1 and 10 in A2. For a descending sequence, enter the larger value first, such as 20 in A1 and 18 in A2. Press Enter after each value.
Select the examples together. Click A1 and drag to A2 so both starting cells are selected. The selection tells Excel how to calculate the interval: 1 and 2 imply a step of 1; 5 and 10 imply a step of 5; 20 and 18 imply a step of -2. If the cells are in a row instead, select both cells from left to right.
Locate the fill handle. Move the pointer to the small square at the lower-right corner of the selected range. When the pointer changes to a small black plus sign, the fill handle is ready. If you cannot see it, check that you are at the edge of the selection rather than inside a cell.
Drag to extend the pattern. Hold the mouse button and drag the fill handle down to fill more rows, or to the right to fill more columns. For example, dragging the selected 1 and 2 in A1:A2 down through A10 produces 1 through 10. Release the mouse button when the outline reaches the last cell you want to fill.
Check the result and choose a fill option if needed. Look through the new cells to make sure the interval is correct. If the small Auto Fill Options button appears near the filled range, click it to review available fill choices, such as filling the series or copying the cells. The exact options depend on what you selected. You can also undo immediately with Ctrl+Z on Windows if the fill replaced something or produced the wrong pattern.
Use the Series command for a precise endpoint or increment. Enter a starting value in a cell and select the range you want to fill, including that starting cell. On the ribbon, choose Home > Fill > Series. In the dialog, choose Rows or Columns to match the direction of the selected range, then choose Linear for a constant addition or subtraction. Enter the Step value, and optionally enter a Stop value. Select OK. For example, with 3 in A1 and A1:A6 selected, a Step value of 4 creates 3, 7, 11, 15, 19, 23. A Stop value limits the series; Excel does not keep adding values beyond it.
Use a formula when the sequence should update from a prior cell. With the starting number in A1, enter the next number in A2. In A3, enter =A2+1, then press Enter. This assumes A2 contains 2 and returns 3 in A3. Select A3 and drag its fill handle down to continue the formula. Each filled formula adds 1 to the value immediately above it. To count by another amount, replace 1 with the desired increment, such as 5. To count downward, use a subtraction formula such as =A2-2, assuming A2 contains 20; it returns 18.
Generate a fixed-length sequence with SEQUENCE, if available. In a blank area, select the cell where the first result should appear and enter =SEQUENCE(10,1,1,1). This assumes you want ten numbers in one column, starting at 1 and increasing by 1; the results spill into ten cells, from 1 to 10. The arguments represent rows, columns, starting value, and step. SEQUENCE is available in Microsoft 365 and Excel 2021 or later. Make sure the cells below the formula are empty, or Excel may show a spill error instead of displaying the results.

The fill handle and Series dialog are often the quickest choices for a one-time sequence. A formula is more useful when later values should respond to changes in earlier cells. SEQUENCE is convenient when you know the number of rows and want a whole range created from one formula.

In Excel for Mac, the fill handle and Home > Fill > Series are available, though ribbon layout and keyboard shortcuts can vary by release. In Excel for the web, you can usually extend values with the fill handle; if the Series dialog is not available in your current web version, use two seed values and drag, or enter a formula. The instructions above use the Windows desktop ribbon.

Common Mistakes

Dragging one value and expecting Excel to count. A single selected value may be copied into each destination cell. Give Excel two values when you want it to infer a step, or use the Series dialog to specify one.
Starting with examples that do not show the intended pattern. If you enter 2 and 5, Excel infers an interval of 3, so the next values are 8, 11, and 14. If you intended to count by ones, start with 2 and 3 instead.
Selecting only the first cell of a pattern. When the selection contains just one seed, Excel cannot know whether you want a constant value or a changing sequence. Select both example cells before dragging.
Filling over existing data. Dragging or using Fill can replace cells in the destination range. Confirm the range is empty, or make a copy of the worksheet before changing important data.
Using numbers stored as text. Values imported with a leading apostrophe or stored as text may not behave like numeric values. A small green triangle may mark a number stored as text. Use the warning icon to convert it to a number when appropriate, or re-enter the values as numbers.
Expecting a non-linear pattern from two seeds. Two values are enough to infer a constant step, but not a more complex rule such as doubling, alternating values, or a custom calendar pattern. Use the Series options, a suitable formula, or provide more examples and check the outcome carefully.

Tips

Plan your direction before filling. Put a vertical sequence in a column and a horizontal sequence in a row. In the Series dialog, select Columns or Rows to match that layout.
Use the Series dialog for negative and larger steps. A Step value of -1 counts down by ones, while a Step value of 100 adds one hundred each time. The dialog is more dependable than guessing what Excel will infer from an unusual pair of examples.
Format after generating the sequence. Use the Home tab’s number-format controls to display thousands separators, decimals, or other formats. Formatting changes how values look, not the underlying numbers. Avoid a date or text format if you need to use the results as ordinary numbers.
For a date sequence, use actual dates. Enter a real Excel date and use the fill handle or the Series dialog. Excel can extend dates by days, months, or years through the Series dialog’s Date unit options. A date that was entered as text may not extend as expected.
Keep formulas when the sequence should stay linked. If later values should adjust when you change an earlier value, fill a formula such as =A2+1 rather than converting the results to fixed numbers. If you need permanent values, copy the results and use Paste Special > Values.
Use an endpoint deliberately. If you need values to stop at a particular number, set a Stop value in the Series dialog or decide the destination range before dragging. With a step that does not land exactly on the endpoint, the last value may be the final one below the stop value rather than an exact match.

Troubleshooting

Every cell repeats the same number: Undo the fill with Ctrl+Z, select two seed values that show the intended interval, and drag again. Alternatively, use Home > Fill > Series and set the Step value yourself. If the Auto Fill Options button is visible, confirm that the series option is selected rather than copy cells.

The sequence has the wrong increment: Check the difference between the two seed values. Excel extends that difference, so 10 and 15 continue as 20, 25, and so on. Start with a clearer pair or specify the exact increment in the Series dialog. For a decreasing series, make sure the step is negative.

The fill handle is missing or will not drag: Confirm you have selected a cell or range and are pointing at its lower-right corner. In desktop Excel, open File > Options > Advanced and, under Editing options, make sure Enable fill handle and cell drag-and-drop is checked. Excel for Mac uses its own settings layout, so look in Excel > Settings or Preferences for editing options. In a browser, check whether the workbook is in a mode that allows editing.

A formula shows an error or does not spill: Check that the formula begins with an equals sign and that the cells where results should appear are empty. A SEQUENCE formula returns a spill error if cells in its output area are occupied or merged. Clear the obstructing cells or move the formula to a clear area. If Excel displays the formula as text, change the cell format to General, then re-enter the formula.

Values look like dates, or numbers lose leading zeros: Excel may apply a number format automatically, or treat an identifier as a number. Change the display format from the Home tab when it is only a display issue. For codes that must retain leading zeros, use a text format or a custom number format; do not assume a numeric sequence will preserve them automatically.

Frequently Asked Questions

How do I make Excel count from 1 to 100?
Enter 1 and 2 in consecutive cells, select both, and drag the fill handle until the sequence reaches 100. For a formula-generated list in Microsoft 365 or Excel 2021 and later, enter =SEQUENCE(100,1,1,1) in an empty cell. It returns 100 rows, from 1 through 100.

How do I continue a sequence by 5?
Enter two values five apart, such as 5 and 10, select them, and drag the fill handle. Or enter 5 as the Step value in Home > Fill > Series. The next values will be 15, 20, and 25.

Can I fill a number sequence across columns?
Yes. Put the starting values in adjacent cells in the same row, select both, and drag the fill handle to the right. With the Series dialog, select Rows for a horizontal range.

Can Excel continue a sequence without dragging?
Yes. Select the destination range and choose Home > Fill > Series to create a sequence with a chosen step and optional stop value. In Microsoft 365 or Excel 2021 and later, SEQUENCE can generate a specified number of results from a single formula.

Why does Excel copy my number instead of continuing it?
Excel may have only one starting value to work from, or the fill option may be set to copy cells. Undo, enter a second value that demonstrates the desired step, select both values, and drag again. For complete control, set the step in the Series dialog.

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.