Generates a list of sequential numbers in an array.
Syntax
SEQUENCE(rows, [columns], [start], [step])Arguments
rowsrequired
The number of rows to return.
columnsoptional
The number of columns to return.
startoptional
The starting number in the sequence.
stepoptional
The amount to increment each subsequent value.
The SEQUENCE function creates a dynamic array of sequential numbers based on specified dimensions and increments. It is particularly useful for generating lists of dates, times, or index numbers that automatically spill into adjacent cells.
=SEQUENCE(3, 1, 1, 1)→1, 2, 3Creates a vertical list of 3 numbers starting at 1 with a step of 1.
Select the target cell
Click on the cell where you want the sequence to begin.
Enter the formula
Type =SEQUENCE followed by the desired rows, columns, start, and step values.
This error occurs if there is not enough empty space in the adjacent cells to display the entire array.