Sequence Excel Column: Create Numbers with SEQUENCE

Formulas & functions · Updated November 18, 2026

To create a sequence of numbers down an Excel column, enter =SEQUENCE(10) in the first cell; in Microsoft 365 or Excel 2021 and later, it spills the numbers 1 through 10 into the cells below. Change the formula’s arguments to choose the number of rows, starting value, and step. If you meant the sequence of Excel column letters instead, those run A to Z, then AA, AB, and onward.

What SEQUENCE does in Excel

SEQUENCE generates an array of consecutive numbers. It can return one column, one row, or a rectangle of numbers, and Excel places the results in neighboring cells automatically. This behavior is called spilling. The formula lives in the first cell of the output, while the remaining results are displayed in the cells the array occupies.

This is useful for numbered lists, test data, date calculations, and creating a set of values without typing or dragging a fill handle. Unlike a manually entered list, the results are linked to the formula: changing an argument recalculates the entire sequence. The function does not, by itself, insert worksheet rows or assign permanent identifiers to records. It returns values in cells.

SEQUENCE is available in Microsoft 365 and Excel 2021 or later. A workbook containing it may show a compatibility warning or a different result in older Excel versions that do not support dynamic arrays. For those versions, use the fill handle or the older formula approaches described below.

SEQUENCE syntax and arguments

The function’s syntax is SEQUENCE(rows,[columns],[start],[step]). The square brackets in this description mean an argument is optional; do not type the brackets into a formula. Arguments control the shape and values of the returned array:

  • rows: How many rows of results to return. This is the required argument.
  • columns: How many columns to return. If omitted, Excel returns one column.
  • start: The first number. If omitted, the sequence starts at 1.
  • step: How much to add between values. If omitted, Excel adds 1 each time.

For example, specifying 10 rows and leaving the other arguments out produces 1, 2, 3, and so on through 10. To make a row instead, set rows to 1 and columns to the desired width. The arguments describe the array’s dimensions first, followed by its starting value and increment.

Create a simple numbered column

With an empty worksheet area and room for ten results below A2, enter this formula in A2:

=SEQUENCE(10)

Excel fills A2:A11 with 1 through 10. The formula is entered only once. If any cell in that output range already contains content, Excel cannot place the full result and may show a #SPILL! error. Clear the obstructing cells or move the formula to a clear area.

To start somewhere other than 1 or count by a different amount, use all four arguments. With a clear output range of five cells beginning at A2, this formula returns 10, 8, 6, 4, and 2:

=SEQUENCE(5,1,10,-2)

Here, 5 is the row count, 1 is the column count, 10 is the starting value, and -2 is the step. A negative step counts downward. A decimal step is also allowed, so a sequence can represent increments such as 0.5. The values are numeric, which means you can use them in calculations and apply number formatting separately.

Make a sequence based on a data range

When a source list grows or shrinks, it can be convenient to generate one number for each expected source row. With source entries in A2:A20 and an empty destination beginning at B2, use:

=SEQUENCE(ROWS(A2:A20))

ROWS(A2:A20) returns 19, so the formula spills 1 through 19 in B2:B20. This counts the rows in the stated range, not the nonblank cells. That distinction matters when the source range contains gaps or when its size changes: a fixed reference to A2:A20 always describes 19 rows.

If you instead want the output length to reflect the number of nonempty cells in a bounded source range, with source data in A2:A100 and an empty destination at B2, use:

=SEQUENCE(COUNTA(A2:A100))

If 12 cells in that source range are nonempty, this produces 1 through 12. It creates a compact list of numbers; it does not preserve the source rows’ positions. For instance, if A2, A4, and A5 contain values while A3 is blank, COUNTA returns 3 and the formula outputs three consecutive numbers. It does not leave a blank number beside the blank source row. Choose the row-count method or nonblank-count method according to how the source data is structured.

Use a fill handle when you do not have SEQUENCE

The fill handle is a practical alternative in older Excel versions, or when you want to create fixed values rather than maintain a formula. Enter 1 in the first cell and 2 in the cell below it, select both cells, then drag the small square at the selection’s lower-right corner down the column. Excel recognizes the pattern and continues it as 3, 4, 5, and so on. Selecting two starting values gives Excel evidence of the interval; dragging a single value generally copies it rather than extending a number pattern.

You can also select the destination range and use the ribbon. On Windows, choose Home > Fill > Series, then set the series direction, type, step value, and stop value in the dialog. The exact choices depend on the selected range and Excel version. On Mac, the Fill Series command is also available from the Home tab, though ribbon layout can vary slightly by version. This method fills cells directly instead of creating a spilling formula.

For a simple list, the fill handle is quick. For a formula-driven list whose length or starting point should update when arguments change, SEQUENCE is usually easier to maintain. For fixed record numbers that must not change if rows are later sorted, consider copying the generated results and using Paste Special > Values.

Number only the rows that contain records

A plain SEQUENCE formula numbers every row in its output range. It does not inspect an adjacent column to decide whether a record exists. If your data has blank rows and you need numbering to remain aligned with the records, a formula copied down row by row may be more appropriate than a single spilled array. For example, with an item in A2, enter this in B2 and fill it down:

=IF(A2="","",COUNTIF($A$2:A2,"<>"))

With entries in A2, A4, and A5, this returns 1 beside A2, leaves B3 blank, then returns 2 and 3 beside A4 and A5. The running COUNTIF counts nonblank cells from the first data row through the current row. This is different from simply putting a compact SEQUENCE beside the data, because the latter would not keep blank-row alignment.

This copied formula is also different from a permanent ID. If rows are inserted, removed, or reordered, sequential row numbers can change. If a number must continue to identify the same record over time, use a stable ID value or another controlled identifier rather than a position-based sequence.

Understand spill errors and formatting

A dynamic array needs an unobstructed destination range. If any cell in the expected spill area contains a value, a space, or another formula, Excel may return #SPILL!. Select the formula cell and inspect the outlined spill range; remove or move the blocking content, or relocate the formula. Merged cells in the output area can also prevent the array from spilling. The results are not individually editable while they belong to the same spilled formula; edit the formula in the top-left cell instead.

Formatting does not change the sequence itself. To display values with leading zeroes, select the output cells and choose Home > Number Format, then apply a custom format such as 000. The underlying values remain numbers, so 1 may display as 001 while still working as the numeric value 1 in arithmetic. If the output is being used as text codes rather than numbers, consider whether numeric formatting is sufficient for the task.

SEQUENCE returns numbers, not dates, but those numbers can represent date serial values when placed in cells formatted as dates. A sequence beginning at a date’s serial number can therefore display consecutive dates if the cells use a date format. Be mindful that the starting number and the cell format jointly determine what appears on screen.

Sequence Excel column letters

Sometimes “sequence Excel column” means generating labels such as A, B, C, through Z, then AA and AB. Those labels are Excel’s column headings, not the numeric output of SEQUENCE. For a list of letters in a worksheet, with the formula in A1 and space below it, enter this formula and copy it down:

=SUBSTITUTE(ADDRESS(1,ROWS($A$1:A1),4),"1","")

In the first row, ROWS($A$1:A1) is 1, so ADDRESS returns A1 and SUBSTITUTE removes the row number, leaving A. Copied down, the row count becomes 2, then 3, and so forth; after Z, Excel’s column-address system produces AA, AB, and the later labels. This formula generates text labels; it does not create worksheet columns. Excel worksheet columns already exist, and the column headings at the top of the grid show their labels.

Choosing the right method

Use SEQUENCE when you have a supported Excel version and want a formula that spills a predictable array. Use the fill handle or Home > Fill > Series when you need a broadly compatible method or direct cell values. Use a row-by-row formula when numbering must follow populated records while preserving gaps. Use a column-letter formula only when the requested output is A, B, C rather than 1, 2, 3.

Also consider whether the sequence is meant to be temporary numbering or a durable identifier. A generated sequence is convenient for display, but it may change when the formula’s size, location, or source data changes. For reports, this is often exactly what is wanted; for keys used to link records between systems, stable values are generally safer.

Frequently Asked Questions

How do I create a sequence of numbers in an Excel column?
In Microsoft 365 or Excel 2021 and later, enter =SEQUENCE(10) in an empty cell with ten clear cells below it. Excel spills 1 through 10 down the column. Change 10 to the number of rows you need.

How do I start an Excel sequence at a number other than 1?
Use the third argument for the starting value. For example, with room for five results, =SEQUENCE(5,1,20,1) returns 20, 21, 22, 23, and 24. The fourth argument sets the increment.

Why does SEQUENCE show a #SPILL! error?
Usually, Excel cannot place all the results because something is in the required spill range. Check for existing values, formulas, or merged cells in that area, clear the obstruction, or move the formula to an empty range.

Can I use SEQUENCE in older versions of Excel?
SEQUENCE is available in Microsoft 365 and Excel 2021 or later, but not in some earlier releases. In an older version, enter the first two numbers and use the fill handle, or use Home > Fill > Series.

How do I generate A, B, C, and then AA in Excel?
Use a column-address formula rather than a numeric SEQUENCE. The ADDRESS and SUBSTITUTE formula above returns A, B, and subsequent labels when copied down; after Z it continues with AA, AB, and so on.

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.