Skip to content
Google Sheets

SEQUENCE function in Google Sheets

Returns an array of sequential numbers, such as 1, 2, 3, 4. .

=SEQUENCE(rows, columns, start, step)

SEQUENCE syntax and parameters

Four arguments, four required.

  • rowsnumberRequired
  • columnsnumberRequired
  • startnumberRequired
  • stepnumberRequired

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 Excel

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 Google Sheets gets this done.