ExamplesFor You
Home / Excel / SEQUENCE
✍️ Excel dynamic arrays examples

SEQUENCE Examples in Excel

Learn practical sequence examples in excel for modern dynamic Excel reports and spill formulas.

Updated 2026-06-125 practical examplesCopy-ready

💡 Ideas for You

Learning resources for Excel formulas, spreadsheets and reporting.

4 useful links

Some links in this section may be affiliate links. Choose only what is useful for your own work.

What it does

SEQUENCE generates a list or grid of sequential numbers.

Syntax or pattern

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

5 practical examples

1

Create numbers 1 to 10

Generate a simple list.

=SEQUENCE(10)

Spills 10 rows.

2

Create monthly periods

Generate 12 month numbers.

=SEQUENCE(12,,1,1)

Useful for model templates.

3

Create dates

Generate a date series.

=DATE(2026,1,1)+SEQUENCE(31)-1

Creates daily dates.

4

Create a grid

Generate a 5 by 3 grid.

=SEQUENCE(5,3)

Rows and columns create the grid.

5

Create every 5th number

Generate steps of 5.

=SEQUENCE(10,,0,5)

The step controls the increment.

Common mistakes to avoid

  • Make sure spill ranges have empty space below or beside them.
  • Use Excel Tables where possible for expanding source data.
  • Older Excel versions may not support all dynamic array functions.

Related Excel examples

FILTER Function Examples in ExcelSORT and SORTBY Examples in ExcelUNIQUE Examples in Excel📊 All Excel examples

FAQ

What is a spill formula?

A spill formula returns multiple cells from one formula entered in a single cell.