Skip to content
ExcelExcel 2021+

SEQUENCE function in Excel

Generates a list of sequential numbers in an array, such as 1, 2, 3, 4

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

SEQUENCE syntax and parameters

Four arguments, one required.

  • rowsnumberRequired

    The number of rows to return

  • columnsnumberOptional

    The number of columns to return

  • startnumberOptional

    The first number in the sequence

  • stepnumberOptional

    The amount to increment each subsequent value in the array

SEQUENCE examples

Formulas you'll actually reuse.

  1. Month numbers 1–12 for a projection table, no typing:

    =SEQUENCE(12)

  2. A 4×3 grid of price points starting at 100, stepping by 25:

    =SEQUENCE(4, 3, 100, 25)

SEQUENCE in Google Sheets

Same name — your formula ports as-is.

Try SEQUENCE in the playground

Edit the example — nothing to install.

Preloaded with the SEQUENCE formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.