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

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.

💡 Useful resources

Here are some ideas for you

Optional resources that may help if you are learning formulas, building reports, or working in spreadsheets often.

  • 📘
    Excel formula books

    Practice formulas with structured examples you can keep beside your desk.

    See ideas
  • ⌨️
    Excel shortcut guides

    Build speed with keyboard shortcuts for selection, formatting and navigation.

    See ideas
  • 🔢
    Numeric keypads

    Helpful if you enter many numbers on a laptop or compact keyboard.

    See ideas
  • 🖥️
    External monitors

    Useful for viewing large worksheets, formulas and reference tables side by side.

    See ideas
  • 📒
    Desk notebooks

    Sketch formula logic, report ideas and table structures before building.

    See ideas
  • 💻
    Laptop stands

    Make long spreadsheet sessions more comfortable and ergonomic.

    See ideas

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