SEQUENCE function in Excel - Step-by-Step Guide

Introduction

The SEQUENCE function creates a list of numbers in a row, column, or grid. It helps you quickly fill cells with numbers without typing each one.

When you want to create a numbered list from 1 to 10 in a column.

When you need a grid of numbers, like 3 rows and 4 columns, for a calendar or table.

When you want to generate a series of numbers starting from a number other than 1.

When you want to fill cells with numbers increasing by 1 automatically.

When you want to create a sequence of numbers for calculations or charts.

Steps

Step 1: Select the cell where you want the sequence to start

- Excel worksheet

The selected cell is active and ready for input

Step 2: Type the SEQUENCE formula with desired parameters

- Formula bar

The formula appears in the cell and the sequence fills the cells automatically

💡 Use =SEQUENCE(rows, columns, start, step). For example, =SEQUENCE(5,1,1,1) creates numbers 1 to 5 in one column

Step 3: Press Enter

- Formula bar

Cells fill with the sequence of numbers as specified

Step 4: Adjust the formula parameters if needed

- Formula bar

The sequence updates automatically to reflect new rows, columns, start, or step values

Before vs After

Before

Cell A1 is empty

After

Cells A1 to A5 show numbers 1, 2, 3, 4, 5 after entering =SEQUENCE(5)

Settings Reference

rows

📍 First argument in SEQUENCE formula

Sets how many rows the sequence will fill

Default: 1

columns

📍 Second argument in SEQUENCE formula

Sets how many columns the sequence will fill

Default: 1

start

📍 Third argument in SEQUENCE formula

Sets the starting number of the sequence

Default: 1

step

📍 Fourth argument in SEQUENCE formula

Sets the increment between numbers in the sequence

Default: 1

Common Mistakes

Entering SEQUENCE without enough arguments

The function may return an error or unexpected results if required arguments are missing

Always provide at least the number of rows, like =SEQUENCE(5) to create 5 numbers in one column

Using negative numbers for rows or columns

Rows and columns must be positive numbers; negative values cause errors

Use only positive whole numbers for rows and columns

Expecting SEQUENCE to fill cells without pressing Enter

The formula needs to be confirmed by pressing Enter to show results

After typing the formula, press Enter to see the sequence fill the cells

Summary

SEQUENCE creates a list or grid of numbers automatically in cells.

You control rows, columns, start number, and step size with simple formula arguments.

Remember to use positive numbers for rows and columns and press Enter to apply.