Excel SEQUENCE Examples for Numbers, Dates, and More

Excel’s SEQUENCE function creates a spill range of consecutive numbers or other values: enter =SEQUENCE(5) in a blank cell to return 1 through 5 vertically. Change its row count, column count, starting value, and step to make a horizontal list, a grid, a countdown, or a date series.

What SEQUENCE does

SEQUENCE generates an array of values from one formula. In Microsoft Excel for Microsoft 365 on Windows, the result spills into neighboring cells automatically; you do not have to copy a formula down a column. This makes it useful for numbered lists, schedules, test data, and other ranges whose size may change.

The function is available in Microsoft 365 and Excel 2021 or later. It also works in supported versions of Excel for Mac and Excel for the web, though ribbon details and some interface behavior can vary. If a workbook is opened in an older Excel version that does not support the function, the formula may appear as an unsupported-function error rather than as a list.

A spilled array has one formula, in its top-left cell, and a result in each cell it occupies. If you change the formula’s inputs, Excel recalculates the array and adjusts its size. The other cells in the spill range are results, not separate formulas to edit individually.

Understand the syntax

The function’s syntax is SEQUENCE(rows,[columns],[start],[step]). Rows is required; the other arguments are optional. Rows and columns set the array’s dimensions, start is the first value, and step is the amount added between values. If columns, start, or step are omitted, Excel uses 1 for each.

Rows: how many rows the result should occupy.
Columns: how many columns it should occupy.
Start: the first number in the sequence.
Step: the increase or decrease from one value to the next.

For example, a step of 1 counts upward by ones, while a step of -1 counts downward by ones. The step can also be a decimal, such as 0.5, or a larger interval such as 10. The number of rows and columns controls the array’s shape; it does not change the increment pattern.

Basic number sequence examples

With no input cells required, enter this formula in A1 to create a five-row list:

=SEQUENCE(5)

The result in A1:A5 is 1, 2, 3, 4, and 5. To create a list across a row instead, make rows equal to 1 and columns equal to 5. With no input cells required, enter this in A1:

=SEQUENCE(1,5)

It returns 1, 2, 3, 4, and 5 horizontally across A1:E1. This distinction is useful when another formula or chart expects the data in a particular orientation.

To begin at 10 and increase by 5, use a one-row, five-column sequence. With no input cells required, enter this in A1:

=SEQUENCE(1,5,10,5)

The result is 10, 15, 20, 25, and 30. For a descending list, set the step to a negative number. With no input cells required, enter this in A1:

=SEQUENCE(4,1,20,-2)

This returns 20, 18, 16, and 14 vertically. The last value is determined by the requested number of rows and the step; Excel does not need a separate ending value.

Create two-dimensional sequences

Set both the row and column arguments to make a rectangular array. With no input cells required, enter the following formula in A1:

=SEQUENCE(3,4)

Excel fills A1:D3 with the numbers 1 through 12, moving left to right across the first row, then continuing on the next row. The result is three rows by four columns. This can quickly produce a numbered grid for a worksheet layout, a small test table, or an illustration of row and column references.

You can also set the starting value and increment for a grid. With no input cells required, enter this formula in A1:

=SEQUENCE(2,3,10,10)

The result is a two-by-three array containing 10, 20, and 30 in the first row, followed by 40, 50, and 60 in the second. The step applies as Excel moves through the array in row order; it does not restart at the beginning of each row.

That behavior matters when planning the array. If you need each row to repeat a pattern or restart its numbering, a single SEQUENCE formula may not express the layout by itself. You may need a different formula design, or separate formulas for separate rows.

Use SEQUENCE for dates and intervals

Excel stores dates as serial numbers, so a step of 1 advances by one day. To make a seven-day list beginning January 1, 2026, with no input cells required, enter this formula in A1:

=SEQUENCE(7,1,DATE(2026,1,1),1)

The underlying results correspond to January 1 through January 7, 2026. If the cells display numbers instead of dates, select the spill range and apply a date number format from the Home tab. Formatting changes how the values appear, not the stored dates.

For a series that advances by seven days, change the step to 7. With no input cells required, enter this in A1:

=SEQUENCE(5,1,DATE(2026,1,5),7)

After date formatting, the five results are January 5, 12, 19, and 26, followed by February 2, 2026. This is a weekly interval, not a workday-only calendar: weekends are included whenever they fall in the sequence.

A monthly sequence needs a different approach because calendar months have different lengths. You can pass a generated list of month offsets to EDATE. With no input cells required, enter this in A1:

=EDATE(DATE(2026,1,1),SEQUENCE(12,1,0,1))

The formula returns the first day of each month from January through December 2026. Format the result as dates, or use a month-and-year display format if that is easier to read. Unlike adding a fixed number of days, EDATE advances by calendar months.

Build custom lists and dynamic ranges

The start and step arguments make custom numeric patterns straightforward. For example, a list of the first six positive odd numbers needs a start of 1 and a step of 2. With no input cells required, enter this in A1:

=SEQUENCE(6,1,1,2)

The result is 1, 3, 5, 7, 9, and 11. The same method can generate even numbers, multiples, or decimal increments. To generate multiples of 12, for instance, use 12 as the step and 12 as the start; decide the number of rows based on how many multiples you need.

You can also make the sequence length and starting value respond to worksheet inputs. Suppose B1 contains 4 and B2 contains 100. With those values in place, enter this formula in A1:

=SEQUENCE(B1,1,B2,1)

The result is 100, 101, 102, and 103 in A1:A4. Change B1 to 6 and the output expands to six rows; change B2 and the starting value changes. This is useful for reusable templates because a user can adjust input cells instead of editing the formula itself.

Before relying on a dynamic range in a report, consider what happens when the requested size changes. Leave enough room beneath and to the right of the formula for the largest expected output. If the array later needs more cells than the available space, Excel cannot place the complete result.

Spill behavior and common problems

The most common issue is #SPILL!. It means Excel cannot place one or more results in the intended spill range. A cell containing a value, a merged cell, or another obstruction in the destination area can prevent the array from appearing. Clear the obstruction or move the formula to a larger blank area, then Excel can recalculate the output.

Another frequent surprise is entering a dynamic-array formula inside an Excel table. Spilled array formulas are not supported within table cells in the same way as ordinary worksheet ranges. Put the formula outside the table, or use a different approach appropriate to the table’s calculated-column behavior.

Confirm the formula is in a cell with enough empty space for every result.
Check that the rows and columns arguments produce the intended dimensions.
Format date serials as dates if they appear as numbers.
Do not try to edit an individual result cell; change the formula in the top-left cell instead.
Check the Excel version if the function name is not recognized.

A sequence is numeric even when it represents dates. For instance, changing a date-formatted result to General may reveal serial numbers. That does not necessarily mean the date calculation failed; it may only need an appropriate number format.

When to choose SEQUENCE or another method

Use SEQUENCE when the values follow a regular numeric or date interval and you want the output size to be controlled by a formula. It is compact, easy to adjust, and particularly convenient when the list length changes. For a fixed list that will not change, typing values or using Excel’s fill handle can be more transparent for a small one-off task.

For dates that must skip weekends or holidays, a simple daily sequence is not enough because it includes every calendar day. A workday-specific function or a more tailored formula is a better fit. Similarly, SEQUENCE alone does not generate arbitrary text labels or irregular business rules; it generates a regular progression of numbers that other functions can transform when needed.

Use a normal fill series when you prefer to create fixed values rather than keep a live formula. Use SEQUENCE when recalculation and resizing are benefits. One practical consideration is compatibility: people using older Excel versions may not see the spilled result correctly, so check the recipient’s software before relying on a dynamic-array formula in a shared workbook.

Frequently Asked Questions

How do I create a list of numbers in Excel automatically?
In a blank cell, enter =SEQUENCE(10) to spill the numbers 1 through 10 down a column. Change 10 to the number of rows you want. This function requires a version of Excel that supports dynamic arrays, such as Microsoft 365 or Excel 2021 and later.

How do I make SEQUENCE go across columns?
Set the rows argument to 1 and the columns argument to the number of values you need. For example, =SEQUENCE(1,5) returns five values across one row rather than down one column.

Can Excel SEQUENCE create dates?
Yes. Start with a valid Excel date and use a step of 1 for consecutive days. Format the resulting cells as dates so the serial values display in a readable date format. For calendar-month intervals, use a month-aware function such as EDATE with generated month offsets.

Why does my SEQUENCE formula show #SPILL!?
Excel cannot place the full array because at least one destination cell is blocked or otherwise unavailable. Clear the cells in the intended spill area, unmerge any obstructing cells, or move the formula to an open range.

Can SEQUENCE count backward?
Yes. Use a negative step. For example, =SEQUENCE(5,1,10,-1) returns 10, 9, 8, 7, and 6 down a column. The starting value, step, and requested number of rows determine the final result.

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.