In traditional spreadsheet software, creating a long vertical list of sequential numbers—like 1 through 100, or a list of dates for the entire month—required typing the first two numbers, highlighting them, and manually clicking and dragging the tiny blue square down hundreds of rows.
Google Sheets eliminated this manual labor with the introduction of the SEQUENCE function. SEQUENCE is a dynamic array formula that generates entire grids of sequential numbers with a single command.
In this guide, you will learn the mechanics of the SEQUENCE function and how to use it to generate custom lists, schedules, and complex matrices.
The SEQUENCE Syntax
The SEQUENCE function requires four arguments, though only the very first one is mandatory.
=SEQUENCE(rows, [columns], [start], [step])- rows: How many rows of numbers you want to generate vertically.
- columns (optional): How many columns of numbers you want to generate horizontally (defaults to 1).
- start (optional): The specific number you want the sequence to begin with (defaults to 1).
- step (optional): The increment by which each number should increase (defaults to 1).
Use Case 1: Generating a Basic Vertical List
If you are building an employee database and need 250 sequential ID numbers in Column A, you do not need to drag anything.
Click into cell A2 and type:
=SEQUENCE(250)Google Sheets instantly spills the numbers 1 through 250 straight down the column. If you change the formula to =SEQUENCE(500), it instantly expands. This is much faster and cleaner than manual dragging.
Use Case 2: Generating Custom Increments (The Step Argument)
The optional arguments make SEQUENCE incredibly powerful for generating specific numerical patterns.
Suppose you are creating a schedule where you need a list of times in 15-minute intervals, or perhaps you just need a list of every even number up to 100. Let’s create a list of 50 numbers, starting at the number 10, and increasing by 5 each time (10, 15, 20, 25…).
=SEQUENCE(50, 1, 10, 5)Here is how it reads:
- 50: Generate 50 rows.
- 1: Keep it in 1 single column.
- 10: Start the sequence with the number 10.
- 5: Step (increase) by 5 every row.
Use Case 3: Generating a Sequence of Dates
In Google Sheets, dates are stored internally as simple sequential serial numbers (e.g., January 1, 2024 is technically the number 45292). Because dates are just numbers, the SEQUENCE function handles them perfectly.
Imagine you want to generate a list of every single day in a specific month, starting from today’s exact date.
=SEQUENCE(30, 1, TODAY(), 1)This formula generates 30 rows in 1 column. It uses the TODAY() function as the starting number, and the step is 1 (one day). The output might initially look like a random string of five-digit numbers. Simply highlight the column, click Format > Number > Date, and they will instantly transform into perfectly formatted sequential dates.
Use Case 4: Creating a 2D Matrix
SEQUENCE is not limited to single columns. If you are building a calendar or a testing matrix, you can populate a 2D grid instantly.
=SEQUENCE(5, 7)This creates a grid that is 5 rows tall and 7 columns wide (35 cells total). It will count from 1 to 7 across the first row, then wrap around to 8 to 14 on the second row, filling the entire matrix perfectly.
By mastering the SEQUENCE function, you can automate the foundational structure of your dashboards and calendars, eliminating manual data entry.