SEQUENCE Function in Excel: Generate Number Lists, Dates & More Without Typing a Single Value!

Have you ever sat down to prepare a report and found yourself manually typing 1, 2, 3, 4, 5... all the way to 100 in Excel? Or maybe you needed to list the first 12 working days of the month and ended up copying and pasting dates one by one? We have all been there. It is tedious, time-consuming, and honestly — completely unnecessary.

Meet the SEQUENCE function — one of Excel's most underrated yet incredibly powerful Dynamic Array functions. It lets you automatically generate a list of sequential numbers (or even dates!) with just one formula. No more typing. No more dragging. Just one clean formula and Excel does all the heavy lifting for you.

What Is the SEQUENCE Function?

The SEQUENCE function generates an array of sequential numbers based on the parameters you provide. It was introduced as part of Excel's Dynamic Array engine in Microsoft 365, and it works in Excel for Windows, Mac, and Excel Online.

Basic Syntax:

=SEQUENCE(rows, [columns], [start], [step])

Here is what each argument means:

rows — How many rows of numbers you want

columns — How many columns (optional, default is 1)

start — The starting number (optional, default is 1)

step — The increment between each number (optional, default is 1)

Step-by-Step Examples — Let's See It in Action

Example 1: Generate Numbers from 1 to 10

Type this formula in any cell:

=SEQUENCE(10)

Result: Excel instantly fills 10 rows with 1, 2, 3... 10. You typed ONE formula. Excel did the rest.

Example 2: Create a 4 x 3 Grid of Sequential Numbers

Want a matrix of numbers? Try this:

=SEQUENCE(4, 3)

Result: A grid of 4 rows and 3 columns filled with 1 through 12. Perfect for creating structured templates or test data for your dashboards.

Example 3: Start from 100 and Count by 5

Need a custom numbering system for invoices, product codes, or exam scores?

=SEQUENCE(10, 1, 100, 5)

Result: 100, 105, 110, 115... up to 145. Great for generating product IDs, score sheets, or any numbered list with a custom step.

Real-World Application — How SEQUENCE Saves Time at Work

Let me give you a real scenario that every professional faces.

Imagine you are an HR executive and you need to create an attendance sheet for 30 employees for the month of April. You need serial numbers 1 to 30 in column A.

Old way: Type 1, type 2, drag down... 30 steps minimum.

With SEQUENCE:

=SEQUENCE(30)

Done in 1 second. And if you add a new employee later and change 30 to 31, the list updates automatically. That is the magic of dynamic arrays.

Bonus Use Case: Generate a List of Dates

Want to generate dates starting from April 1, 2026 for 30 days? Use SEQUENCE with a start date:

=SEQUENCE(30, 1, DATE(2026,4,1), 1)

Then format the column as a Date and you instantly get April 1, April 2, April 3... all the way to April 30. No manual entry. No errors. Clean and automatic.

Power Move: Combine SEQUENCE with Other Functions

SEQUENCE becomes even more powerful when you combine it with other Dynamic Array functions. Here are a few combinations professionals love:

1. SEQUENCE + TEXT — Generate formatted date labels like "Apr-01", "Apr-02" for reports:

=TEXT(SEQUENCE(30, 1, DATE(2026,4,1), 1), "mmm-dd")

2. SEQUENCE + INDEX — Pull every nth row from a dataset dynamically, without manual filtering.

3. SEQUENCE + CHOOSE — Create rotating weekly schedules or category lists automatically.

Every time you combine SEQUENCE with another function, you build something that updates itself automatically. Your reports become self-maintaining. Your templates become reusable. Your time gets freed up for the work that truly matters.

Takeaway & Bonus Tip

The SEQUENCE function is one of those tools that, once you start using it, you cannot imagine going back to manually typing numbers. It is simple, flexible, and works beautifully with the rest of Excel's modern formula engine.

Quick Summary of What You Learned Today:

- Generate a simple numbered list: =SEQUENCE(10)

- Create a multi-column grid: =SEQUENCE(4, 3)

- Custom start and step: =SEQUENCE(10, 1, 100, 5)

- Generate dates: =SEQUENCE(30, 1, DATE(2026,4,1), 1)

Bonus Tip: Use SEQUENCE inside a MAKEARRAY or LAMBDA function to build fully custom dynamic grids and calculators — all without a single line of VBA code!

If you found this useful, share it with a colleague who is still typing serial numbers manually. Let them discover the power of SEQUENCE today!

— Roopkumar Murali | Excel Wizardd