# SEQUENCE

#### Syntax 1 <a href="#syntax.47" id="syntax.47"></a>

**SEQUENCE**(*range*)

* *range* - a range that is to be filled with sequential numbers - ***Value type**: widget*

Returns a range with the same number of rows and columns as *range*, filled with a sequence of integers, starting from 1. The integers are incremented row-by-row.

**Syntax 2**

**SEQUENCE**(*numRows;* *numColumns*)

* *numRows* - the number of rows of the result range - ***Value type**: number*
* *numColumns* - the number of columns of the result range - ***Value type**: number*

Returns a range with *numRows* and *numColumns*, with a sequence of integer values, starting from 1, up to *numRows* x *numColumns*.

#### Remarks

* The maximum amount of cells which can be created by the SEQUENCE function is 100,000
* Each parameter allows a maximum value of 9,999.

#### Examples <a href="#examples.11" id="examples.11"></a>

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/K2cqjHIjPybzLzlNQkoa/image.png" alt=""><figcaption></figcaption></figure>

<div align="left"><figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/hwwQL3EP8B7xXce1ig8U/grafik.png" alt=""><figcaption></figcaption></figure></div>

<div align="left"><figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/KE3bRntI3o4bdPg9sp3d/grafik.png" alt=""><figcaption></figcaption></figure></div>