Historically, if you needed to generate a simple column of sequential numbers in Microsoft Excel (e.g., 1 to 100 for a row ID column), you had to manually type the first two numbers, click the tiny green square in the corner of the cell, and physically drag your mouse down exactly 100 rows. This manual dragging process is tedious, prone to human error, and incredibly frustrating if you need a sequence of 10,000 numbers. To instantly spawn massive, dynamic arrays of sequential numbers, you must use the modern SEQUENCE function.
How the SEQUENCE Function Works
Introduced in Excel 2021 and Office 365, the SEQUENCE function is a dynamic array formula. This means you type the formula into a single, solitary cell, and the resulting numbers will automatically “spill” down the column (or across the row), instantly filling up as much space as required.
The syntax is: =SEQUENCE(rows, [columns], [start], [step])
To generate a basic list of numbers from 1 to 100 straight down a single column, click into cell A2 and type:
=SEQUENCE(100)When you press Enter, Excel instantly generates exactly 100 rows of data. You do not drag the formula. You do not copy and paste. The numbers simply manifest on the screen.
Advanced Sequence Customization
The true power of the SEQUENCE function lies in its optional parameters.
Imagine you want to generate a sequence of 50 numbers, but you want them to be displayed across a single horizontal row rather than a vertical column. You use the second argument:
=SEQUENCE(1, 50)This tells Excel: “Give me exactly 1 row, but span it across 50 columns.”
If you are building a financial model and need a column of years starting at 2025 and incrementing by 5 years at a time (e.g., 2025, 2030, 2035), you can use the [start] and [step] arguments.
=SEQUENCE(10, 1, 2025, 5)This commands Excel to generate 10 rows (down a single column), starting at the raw number 2025, and adding exactly 5 to every subsequent number in the chain. If you ever need to expand the list to 20 rows, you simply change the first number in the formula from a 10 to a 20, and the entire array instantly redraws itself.