Function Problems

How to Generate Sequential Numbers in Excel Without VBA

Jason Miller Oct 21, 2026 868 views

Question details

The user needs to generate sequential numbers in a spreadsheet automatically without relying on complex VBA macros.

How to Generate Sequential Numbers in Excel Without VBA

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a dynamically numbered list or auto-filling sequential values efficiently in a spreadsheet.
Observed behavior: Depending on the user's Excel version and data structure, a reliable numbering method is needed that either spills values automatically or adapts seamlessly when rows are deleted.

Before you start

Check your Excel version (e.g., Microsoft 365, Excel 2021, or older) and determine if your numbered list needs to automatically recalculate when rows are deleted, as this dictates the best formula approach.

Solution 1Recommended

Generate Sequential Numbers Using the SEQUENCE Function

For users with Excel 2021 or Microsoft 365, the SEQUENCE function is the most efficient way to generate dynamic arrays of numbers.

The SEQUENCE function is a modern dynamic array formula that automatically spills results into adjacent cells without the need to drag the fill handle.

Select the starting cell

Click on the specific cell where you want your sequential numbering to begin.

Enter the SEQUENCE formula

Type =SEQUENCE(10, 1, 1, 1) into the formula bar. Replace '10' with your desired number of rows, and the third '1' with your desired starting number.

Press Enter to spill

Press Enter on your keyboard. The sequential numbers will instantly populate down the column for the specified number of rows.

Generate Sequential Numbers Using the SEQUENCE Function

Solution 2

Create Auto-Updating Numbers Using the ROW Function

This method is best if you frequently add or delete rows, as the sequence numbers will automatically recalculate.

Solution 3

Apply a Simple Fill-Down Addition Formula

A universally compatible method for older Excel versions where you simply add 1 to the previous cell's value.

Easy Spreadsheet Numbering

Generate Sequential Numbers Seamlessly in WPS Spreadsheet

WPS Spreadsheet offers full support for advanced dynamic array functions like SEQUENCE, as well as traditional ROW formulas, allowing you to number your lists effortlessly without any VBA knowledge.

1. Open your workbook: Launch WPS Spreadsheet and open the document where you need to add sequential numbers.
2. Select your starting cell: Click the cell where you want the sequential numbering to begin.
3. Input the formula: Type =SEQUENCE(20) for a quick list of 1 to 20, or use =ROW()-1 for dynamic numbering.
4. Apply the sequence: Press Enter to instantly populate your sequential list across the targeted rows.

Fully compatible with Microsoft Excel formulas and .xlsx formats.Supports modern dynamic array functions including SEQUENCE and dynamic spilling.Lightweight, fast, and highly efficient for large datasets.Intuitive interface similar to Microsoft Excel for seamless migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why isn't the SEQUENCE function working in my Excel?

The SEQUENCE function is a dynamic array formula available only in Microsoft 365, Excel 2021, and newer versions (as well as WPS Office). If you are using Excel 2019 or older, the function will return a #NAME? error. You should use the ROW function or basic addition instead.

How do I start the SEQUENCE function at a specific number, like 100?

You can customize the starting number using the third argument of the function. For example, typing =SEQUENCE(10, 1, 100, 1) will generate 10 sequential numbers starting exactly from 100.

Can I generate sequential odd or even numbers without VBA?

Yes. You can adjust the step value, which is the fourth argument in the SEQUENCE function. For example, =SEQUENCE(10, 1, 2, 2) generates even numbers starting at 2, while =SEQUENCE(10, 1, 1, 2) generates odd numbers.

How do I stop my sequential numbers from breaking when I sort my data?

If you use the =ROW()-1 formula, the numbers stay strictly tied to the row position, ignoring any data sorting. If you want numbers to stay attached to specific rows of data when sorting, you should copy the generated formula results and paste them as plain values (Ctrl+Shift+V) before applying your sort.

Excel & Data Problems