SEQUENCE Function in Excel: Syntax, Examples and Free Practice
SEQUENCE is an Excel Math & Trig function. Generates a list of sequential numbers in an array.
SEQUENCE syntax
Arguments
rows: How many rows to return or generatecolumns: How many columns to return or generate (optional)start: The starting value (optional)step: The amount to increase by each time (optional)
When to use SEQUENCE
SEQUENCE is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice SEQUENCE online, free
Open the live Excel-style spreadsheet and try SEQUENCE yourself. No Excel install or sign-up needed to start.
Practice SEQUENCE now →Learn more
Read the tutorial: How to use SEQUENCE.
More Math & Trig functions
Frequently asked questions
What does the SEQUENCE function do in Excel?
Generates a list of sequential numbers in an array.
What is the syntax of SEQUENCE in Excel?
The syntax is =SEQUENCE(rows, [columns], [start], [step]). rows: How many rows to return or generate; columns: How many columns to return or generate (optional); start: The starting value (optional); step: The amount to increase by each time (optional).
Where can I practice SEQUENCE online for free?
Open the free live spreadsheet on Cellgrids and try SEQUENCE yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts