How to Use SEQUENCE Function in Excel + Tips

Hello everyone! Today i will show you how to use SEQUENCE function in Microsoft Excel step by step. Very fast and easy formula for make automatic list of numbers, dates, and row numbers!

1. What is SEQUENCE Function in Excel?

The SEQUENCE function is a dynamic array function in Excel 365 and Excel 2024. It allows you to automatically generate a list of sequential numbers in a single column, across a row, or even a whole 2D table grid.

No need to drag formula down anymore! Just type 1 formula, and Excel spills all numbers automatically.

Think of SEQUENCE function like an automatic number counter:

• Make 1 to 100 row number list instantly.
• Generate weekly dates or monthly schedule.
• Create 2D table of numbers automatically.

2. 🛠️ Formula Syntax & Parameters

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

• rows: Required. The number of rows you want to generate (e.g., 10).
• [columns]: Optional. The number of columns to generate (Default is 1).
• [start]: Optional. The starting number of sequence (Default is 1).
• [step]: Optional. The step value to add for each next number (Default is 1). Can use negative number to count down!

3. 📋 Practical Examples

Example 1: Generate Simple 1 to 10 Column List

To make automatic list from 1 to 10 in 1 single column:

=SEQUENCE(10)

👉 Result: Spills numbers 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 straight down in Column!

Example 2: Generate Horizontal Row Numbers (1 to 5)

If you want numbers side-by-side across columns instead of down:

=SEQUENCE(1, 5)

👉 Result: Spills 1, 2, 3, 4, 5 across 1 single row (5 columns wide)!

Example 3: Start from 100 and Step by 10

Generate numbers starting from 100 and adding 10 each step:

=SEQUENCE(5, 1, 100, 10)

Example 4: Automatic Dynamic Row Numbers for Table

Combine SEQUENCE with COUNTA so list number auto-updates when you type new names!

Suppose range B2:B10 has student names:

=SEQUENCE(COUNTA(B2:B10))

👉 Result: Automatically creates row numbers 1, 2, 3... matching exact number of student names entered in Column B!

Example 5: Generate Automatic Dates (Next 7 Days)

Because Excel treats dates as numbers, you can generate date sequences easily!

=SEQUENCE(7, 1, DATE(2026, 9, 1), 1)

👉 Result: Generates 7 consecutive date values starting from Sep 1, 2026 to Sep 7, 2026! (Just format cells as Short Date).

💡 Quick Tips for Using SEQUENCE Function

1. Auto Dynamic Row Index: Use =SEQUENCE(COUNTA(A2:A100)) for your table serial numbers. When you delete or add data in column A, numbers auto-update without break!
2. Count Down / Reverse Sequence: Use negative step value like =SEQUENCE(10, 1, 10, -1) to count down from 10 to 1!
3. Generate Odd or Even Numbers Easily:
   • Odd numbers: =SEQUENCE(5, 1, 1, 2) -> 1, 3, 5, 7, 9
   • Even numbers: =SEQUENCE(5, 1, 2, 2) -> 2, 4, 6, 8, 10
4. Excel Version Requirement: Needs Microsoft 365, Excel 2024, or Excel for Web because it uses dynamic array spilling engine.

📚 Related Resources & Tutorials

• How to Use TAKE Function in Excel
• How to Use CHOOSE Function in Excel
• Top 15 Basic Excel Formulas for Beginners ↗