Add a Sequence in Excel with the SEQUENCE Function

Formulas & functions · Updated November 21, 2026

To add a numbered sequence in Excel, enter =SEQUENCE(10) in a blank cell to spill the numbers 1 through 10 into the cells below it. Change the function’s arguments to control how many numbers appear, where the sequence starts, and how much it increases each time.

What a sequence means in Excel

A sequence is an ordered set of values, often numbers such as 1, 2, 3, or dates such as consecutive days. Excel can create one with the SEQUENCE function, which returns an array of values that fills neighboring cells automatically. This is useful for numbering records, building a calendar, creating test data, or making a list of evenly spaced values.

SEQUENCE is available in Microsoft 365 and Excel 2021 or later, including Excel for the web. It is a dynamic array function: you enter one formula in one cell, and Excel displays its results in the surrounding cells. You do not need to copy the formula down for a simple sequence. The cells occupied by the results are called the spill range.

How to use the SEQUENCE function

The function’s syntax is SEQUENCE(rows,[columns],[start],[step]). Rows is the number of results down the sheet; columns is the number across. Start is the first value, and step is the amount to add between values. Rows is required, while the other arguments are optional. If you leave columns out, Excel uses one column; if you leave start and step out, it starts at 1 and increases by 1.

To make a basic list, put the formula in A2 with A2:A11 and the cells to its right available for the spill range: =SEQUENCE(10). The result is 1 in A2, 2 in A3, and so on through 10 in A11. The formula remains in A2; the other displayed values are generated results, not separate formulas.

For a custom sequence, place the formula in A2 with the cells A2:A6 clear: =SEQUENCE(5,1,10,2). This returns 10, 12, 14, 16, and 18. The arguments specify five rows, one column, a starting value of 10, and a step of 2.

  1. Choose the cell where the first displayed value should appear.
  2. Check that the cells where results need to spill are empty and are not merged.
  3. Enter SEQUENCE with the desired row count, column count, start, and step.
  4. Press Enter. Adjust the formula or formatting if the displayed result needs a different shape or appearance.

Choose the sequence size, direction, and step

Use the first two arguments to set the dimensions. For example, with the formula entered in A2 and the 3-by-4 spill area A2:D4 empty, =SEQUENCE(3,4,1,1) produces three rows and four columns containing 1 through 12, read across each row. This arrangement can help create a numbered grid or a simple calendar layout.

To make a horizontal list, put the formula in A2 with A2:J2 clear: =SEQUENCE(1,10). It spills 1 through 10 across the row. For a vertical list, use one column and the desired number of rows, or omit the columns argument as in the basic example.

The step can be negative or fractional. With the formula in A2 and A2:A5 clear, =SEQUENCE(4,1,10,-2) returns 10, 8, 6, and 4. With the formula in A2 and A2:A4 clear, =SEQUENCE(3,1,0,0.5) returns 0, 0.5, and 1. The step controls the difference between adjacent values; it does not set the number of results.

Create date sequences

Excel stores dates as serial numbers, so a sequence can generate dates by starting from a date value and stepping by one day. With the formula in A2 and A2:A8 clear, =SEQUENCE(7,1,DATE(2026,1,1),1) returns seven consecutive dates beginning January 1, 2026. If the results appear as ordinary numbers, select the spill cells and choose a date format from Home > Number. The underlying values are still dates.

For a weekly sequence, use a step of 7. With the formula in A2 and A2:A6 clear, =SEQUENCE(5,1,DATE(2026,1,1),7) returns five dates, each one week after the previous date. Change the date in DATE to the required starting point. For month-by-month schedules, a fixed step of 30 or 31 days will not reliably land on the same day of each month; calendar months have different lengths. Use a month-aware date method instead when the schedule must follow calendar months.

Number existing rows instead of generating a separate list

A spilled sequence is ideal when you want a separate list of numbers. If each existing record needs a number beside it, a copied formula can be a better fit, especially when rows may be added later. For data in B2:B100, enter this in C2 and copy it down through C100: =IF(B2<>"",COUNTA($B$2:B2),""). If B2, B3, and B4 contain entries, C2:C4 shows 1, 2, and 3. Blank cells in column B leave the corresponding cells in column C blank, and later records are numbered consecutively.

This formula assumes that a cell counts as a record when it is not empty. COUNTA also counts cells containing formulas that return an empty-looking string, so use a different check if that describes your data. The formula is copied row by row, unlike SEQUENCE, which spills results from a single cell. If you simply want a numbered list independent of existing records, SEQUENCE is usually shorter and easier to update.

SEQUENCE compared with Fill Series

SEQUENCE is convenient when the list should update automatically as you change its length, start, or step. It is also useful for producing a rectangular array. However, a spill range needs clear space, and the function requires a compatible Excel version.

For a one-time list or a workbook that must work in older Excel versions, use Excel’s Fill Series command. Enter the first value in a cell and select the cells you want to fill. On Windows, use Home > Editing > Fill > Series, then choose Rows or Columns, a series type, and a step value. You can set a stop value as well. The exact dialog choices depend on the series type. You can also enter the first two values, select both, and drag the fill handle to extend the pattern; Excel uses the difference between the two values to continue a linear series.

Fill Series writes values into cells rather than leaving a single dynamic array formula. That can be preferable when you need fixed values or when recipients use an older version of Excel. Use SEQUENCE when a compact, recalculating formula is more useful than a static list.

Fix common SEQUENCE problems

If Excel displays #SPILL!, it cannot place one or more results in the required cells. Look for existing values or formulas in the spill range, merged cells, or another obstruction. Clear or move the obstructing content, or change the formula’s dimensions. A spill range can also run into the edge of a worksheet if the requested array is too large.

If Excel returns #NAME?, check the spelling and confirm that the Excel version supports SEQUENCE. Excel 2021 and Microsoft 365 support the function; older perpetual versions may not. If a formula appears as text instead of calculating, check that the cell is not formatted as Text, remove any leading apostrophe, and re-enter the formula.

Only the top-left cell of a spilled array can be edited directly. To change its results, edit the formula in that cell. You can format individual spill cells, but you cannot type a different value into one result without replacing or blocking the spill. Dynamic arrays also cannot spill inside an Excel table; put the formula outside the table or use a copied formula in a table column.

Frequently Asked Questions

How do I add numbers 1 to 100 in Excel?
Enter =SEQUENCE(100) in a blank cell with at least 100 cells available below it. Excel spills the integers 1 through 100 down one column.

How do I make a sequence start at a number other than 1?
Use the third argument for the starting value. For instance, with the formula in A2 and A2:A5 clear, =SEQUENCE(4,1,20,1) returns 20, 21, 22, and 23.

Can I create a sequence across columns?
Yes. Set rows to 1 and columns to the number of values wanted. With A2:J2 available, =SEQUENCE(1,10) fills ten values from left to right.

Why does my sequence not update when I add rows?
SEQUENCE uses the row count in its formula; it does not automatically infer how many records you intend to number. Change that argument when the desired list grows, or use a table-based numbering approach if records are regularly added.

Can I use SEQUENCE in older Excel versions?
SEQUENCE is supported in Microsoft 365 and Excel 2021 or later, not in every older release. In an unsupported version, use Fill Series or enter a starting value and extend it with the fill handle.

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.