Excel Next Number in Sequence: Formulas and Tips

Formulas & functions · Updated November 19, 2026

With the first number in A2, enter =A2+1 in A3 to calculate the next number in a sequence that increases by one. For a different step, add that amount instead; to generate a whole list at once in Microsoft 365 or Excel 2021, use the SEQUENCE function.

What “next number” means in Excel

Excel can continue a sequence in several ways, and the best choice depends on the pattern. A simple count such as 10, 11, 12 adds one each time. A sequence such as 10, 15, 20 adds five. Other lists may follow a pattern in which the difference changes, or may contain dates, identifiers, or numbers with missing entries.

It also matters whether you want a value calculated from the previous cell or a set of numbers entered into cells. A formula updates when its input changes. Excel’s Fill Series command writes a series of values, while SEQUENCE creates a formula-driven array that can spill into nearby cells. Knowing the distinction helps you avoid a result that looks right but does not update the way you expect.

For a basic count, a formula is usually the clearest method. If you need a quick fixed list, the fill handle is convenient. For a larger or changing list, SEQUENCE can create the range in one step.

Use a formula to calculate one next number

With 7 in A2 and the next result needed in A3, enter =A2+1. The result is 8. The reference A2 means Excel uses the value in that cell, so if A2 changes, A3 recalculates automatically. This is useful for numbered rows, counters, and lists where each entry should depend on the one before it.

To count by a fixed amount, change the number being added. With 7 in A2 and the next result in A3, enter =A2+3; the result is 10. Copy the formula down to continue the same step. Excel adjusts the relative reference, so the cell below uses the value directly above it.

To copy a formula, select the cell containing it and drag the small square at its lower-right corner, called the fill handle, down the column. You can also copy the cell, select the destination cells, and paste. If the fill handle is not visible or does not work, check Excel’s editing options to ensure that the fill handle is enabled.

A formula is particularly helpful when the sequence must remain connected to an input. For example, a schedule may start from a date or number stored elsewhere; changing that starting value then updates the following entries instead of requiring you to retype the list.

Continue a sequence with AutoFill or Fill Series

For a quick series, type a starting value in a cell and drag its fill handle through the cells you want to populate. When Excel recognizes a simple pattern, it may extend the sequence. To make the intended step clearer, enter two starting values first. For example, type 4 in A2 and 9 in A3, select both cells, then drag the fill handle down. Excel can continue the arithmetic pattern by adding five each time.

For more control, enter a starting number, select the cells to fill, and choose Home > Fill > Series. In the Series dialog, choose whether to fill rows or columns, select a series type, and specify a step value. A step of 1 makes consecutive integers; a step of 5 produces values such as 4, 9, 14, and 19. You can also set a stop value so Excel ends the series at a chosen number.

  • Use the fill handle when you want to extend a visible pattern quickly.
  • Use two or more seed values when the intended increment is not one.
  • Use the Series dialog when you need to state the direction, step, or stopping value explicitly.

AutoFill can also copy formulas, formatting, or other recognized patterns. If Excel copies the same value rather than increasing it, undo the action and try selecting two seed numbers before dragging, or use Fill Series to specify the step directly. The small Auto Fill Options control that appears after dragging may also offer choices such as filling a series or copying cells.

Generate a full list with SEQUENCE

SEQUENCE creates a rectangular array of sequential numbers from one formula. It is available in Microsoft 365 and Excel 2021 or later. With the formula entered in A2 and room for ten results below it, use =SEQUENCE(10,1,1,1). It returns 1 through 10 in a single column: 10 rows, 1 column, starting at 1, with a step of 1.

The function’s arguments are rows, columns, start, and step. With the formula entered in A2 and room for five results across the row, use =SEQUENCE(1,5,10,2). The results are 10, 12, 14, 16, and 18. Change the start or step to suit the task; for example, a step of 1 counts by ones, while a step of 10 generates ten-unit intervals.

SEQUENCE spills its results into neighboring cells. Keep the intended output area clear: if another value blocks the spill range, Excel displays a #SPILL! error. The formula is also dynamic, so changing its row or column arguments changes the size of the output. If you need a fixed list that will not recalculate, you can copy the results and use Paste Special > Values.

In Excel for the web, SEQUENCE is also available in supported Microsoft 365 accounts. Older Excel versions that do not support dynamic arrays may not recognize the function, so use Fill Series or copied formulas when sharing a workbook with those versions.

Continue increments and more complex patterns

For an arithmetic sequence, each number differs from the previous number by a constant amount. If the first two values are 4 and 9, the difference is 5. With 4 in A2 and 9 in A3, enter =A3+(A3-A2) in A4. The result is 14. Copying that formula down continues the same difference because the references move with each row.

This approach works when the difference stays constant. It does not automatically infer every pattern a person might see. For example, 1, 2, 4 could mean doubling, adding a growing amount, or the beginning of some other rule. Excel’s fill feature can recognize common patterns, but it cannot know the intended rule from insufficient information. Provide more seed values or write a formula that expresses the rule explicitly.

For a pattern that changes by a known rule, build that rule into the formula. If each step should double the previous value, with 3 in A2 and the next value in A3, enter =A2*2 in A3 to return 6, then copy down. The next results are 12 and 24. This is different from adding a fixed increment, so choosing the correct operation matters.

When a list represents an established numbering system, consider its real rules before extending it. Some identifiers skip reserved values, reset each year, or include check digits. A basic increment formula will not know about those exceptions; use documented business rules rather than treating every identifier as ordinary counting.

Make sequences of dates and numbered labels

Dates are stored as serial numbers in Excel, so adding a number to a date advances it by that many days. With a date in A2 and the next date needed in A3, enter =A2+1 to return the following day. To create weekly dates, use =A2+7. Format the result as a date if Excel displays a serial value instead. A date formatted as text may not behave like a true Excel date, so check the cell’s value and format if the result looks unexpected.

Text labels with a numeric suffix need a slightly different approach. With the text INV-0042 in A2 and the next label needed in A3, enter ="INV-"&TEXT(VALUE(RIGHT(A2,4))+1,"0000"). The result is INV-0043. RIGHT extracts the last four characters, VALUE converts them to a number, and TEXT formats the incremented value with four digits. This example assumes the prefix is always INV- and the numeric part is exactly four digits.

For a simple text-and-number pattern, AutoFill may extend labels such as Item 1 and Item 2 when both examples are selected. Check the results before relying on it, especially when leading zeros or a fixed number of digits matter. A formula using TEXT can preserve the desired width; a plain increment may turn 0043 into 43.

Find missing numbers in a list

A related task is finding gaps in a list rather than calculating just the next value. Suppose A2:A10 contains numeric entries from a range that should begin at 1 and run through its largest value. In an empty cell, enter =FILTER(SEQUENCE(MAX(A2:A10)),COUNTIF(A2:A10,SEQUENCE(MAX(A2:A10)))=0,"No gaps"). Excel returns any missing integers between 1 and the maximum value, or the text No gaps if none are missing.

This formula uses FILTER and SEQUENCE, available in Microsoft 365 and Excel 2021 or later. It assumes the list contains positive whole numbers and that 1 is the expected starting point. If the expected range begins at a different number, or has a known end that is higher than the current maximum, adjust the generated range to reflect that rule. Also check that the cells contain numbers, not number-looking text, because text entries may not be counted as expected.

For a short list, sorting the values and visually checking adjacent entries may be simpler. For a large list, a formula can flag gaps consistently, but it is still important to define the intended start and end. A missing number cannot be identified without knowing what the complete sequence is supposed to include.

Common problems and how to fix them

  • The same number repeats. You may have dragged one cell, so Excel copied its value. Select two starting values to show the intended difference, or use Home > Fill > Series.
  • The formula displays as text. The cell may be formatted as Text, or the entry may begin with an apostrophe. Change the format to General, then re-enter the formula.
  • The result is not the expected next value. Check the starting cell, the step, and whether the pattern is arithmetic. A formula that adds one cannot continue a sequence that advances by five.
  • SEQUENCE shows #SPILL!. Clear cells in the intended output area. A merged cell or another obstruction can prevent the array from expanding.
  • Dates turn into large numbers. The calculation may be valid, but the result is formatted as General or Number. Apply a date format from the Number Format options on the Home tab.
  • Leading zeros disappear. Excel treats entries such as 0042 as numbers unless formatted otherwise. Use a custom number format or a text formula such as TEXT when the zeros are part of an identifier.

When troubleshooting, click the result cell and inspect the formula bar. Confirm that the formula refers to the intended cell and that the source value is numeric where required. If a formula was copied, look for references that shifted unexpectedly; a reference such as A2 moves when filled down, while an absolute reference such as $A$2 stays fixed.

Which method should you choose?

Use =A2+1 for a straightforward next number that should update when the preceding value changes. Use a modified addition or another explicit calculation when the step is known. Choose AutoFill for a quick extension of a pattern, and Fill Series when you want to specify the step and stopping point. Choose SEQUENCE when a supported Excel version should generate a complete, adjustable array from one formula.

For dates, labels, and gaps, make sure the formula reflects the meaning of the data rather than just its appearance. A date is not simply a label, and an invoice number may have rules beyond arithmetic. The more important the sequence is to a report or process, the more useful it is to document the starting point, increment, and any exceptions near the data.

Frequently Asked Questions

How do I get Excel to automatically continue numbers?
Select two consecutive starting numbers, then drag the fill handle across or down. Excel uses their difference to continue the series. For an explicit step and stop value, select the cells and choose Home > Fill > Series.

How do I get the next number in a cell?
If the current number is in A2, enter =A2+1 in the cell below it. Replace 1 with the increment you need, such as 5 to add five each time.

Can Excel generate numbers without dragging?
Yes. In Microsoft 365 or Excel 2021 and later, SEQUENCE can generate a list from one formula. For example, =SEQUENCE(10) returns ten numbers starting at 1 in a vertical array.

Why does Excel repeat the same number instead of counting?
Excel may be copying a single selected cell rather than inferring a series. Enter and select two seed values, or use Fill Series and set the step value yourself.

How do I continue a sequence that increases by 5?
If the first value is in A2, use =A2+5 in A3 and copy the formula down. Alternatively, select the cells to fill and set a step value of 5 in the Series dialog.

Related

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.