Dynamic arrays function

Excel SEQUENCE function

Q: How do I auto number rows in Excel?

Type =SEQUENCE(COUNTA(B2:B100)) next to your list. It numbers every filled row and grows as you add more.

Q: How do I create a list of dates in Excel with a formula?

Add SEQUENCE to a start date: =A2+SEQUENCE(30,1,0,1) gives 30 days in a row. Use a step of 7 for weekly dates.

SEQUENCE creates a list of numbers that spills into as many rows and columns as you ask for. Use it to number rows, build weekly date schedules, or generate test data without dragging the fill handle.

=SEQUENCE(rows, [columns], [start], [step])

Arguments

rows: How many rows to fill.
columns: Optional. How many columns to fill. Default is 1.
start: Optional. The first number. Default is 1.
step: Optional. How much to add each time. Default is 1.

SEQUENCE examples

Every result below was calculated from this sample sheet by the same spreadsheet engine the Cellwise app uses.

	A	B
1	Sprint start	Team
2	2026-01-05	Platform

=SEQUENCE(5)
Result: spills 5 rows × 1 column
1
2
3
4
5
Spills 1, 2, 3, 4, 5 down a column.
=SEQUENCE(3,4,10,5)
Result: spills 3 rows × 4 columns
10 15 20 25
30 35 40 45
50 55 60 65
A 3-row, 4-column grid starting at 10 and counting up by 5.
=A2+SEQUENCE(6,1,0,14)
Result: spills 6 rows × 1 column
46027
46041
46055
46069
46083
46097
Six sprint start dates two weeks apart, starting January 5, 2026.
=SUM(SEQUENCE(12))
Result: 78
Adds 1 through 12 without typing them: 78.

How to use SEQUENCE

Click the top-left cell of an empty area.
Type =SEQUENCE( and the number of rows.
Add columns, a start number and a step if you need them.
Press Enter. Format the cells as dates if you built a date list.

Common SEQUENCE mistakes

Getting #SPILL!

The cells the list needs are not empty. Clear them or move the formula.

Date lists show as numbers

Dates plus SEQUENCE give serial numbers. Format the spill range as dates.

Mixing up start and step

The order is rows, columns, start, step. SEQUENCE(5,1,0,7) starts at 0 and adds 7.

SEQUENCE FAQ

How do I auto number rows in Excel?

Type =SEQUENCE(COUNTA(B2:B100)) next to your list. It numbers every filled row and grows as you add more.

How do I create a list of dates in Excel with a formula?

Add SEQUENCE to a start date: =A2+SEQUENCE(30,1,0,1) gives 30 days in a row. Use a step of 7 for weekly dates.

Which Excel versions have SEQUENCE?

Microsoft 365, Excel 2021 and later, and Excel for the web. Older versions do not support spilling formulas.