Function Problems

How to Fill a Column with Numbers 1 Through 20 in Excel

Aamir Naveed Akram Oct 22, 2026 868 views

Question details

The user wants to generate a vertical sequence of numbers from 1 to 20 in a spreadsheet column without manually typing each number.

How to Fill a Column with Numbers 1 Through 20 in Excel

Product: Excel
Device & OS: not provided
Scenario: Creating a sequential numbered list for data entry, row tracking, or setting up a numbered index.
Observed behavior: Needs a quick and automatic way to populate a column with a consecutive series of numbers from 1 to 20.

Before you start

Select the empty starting cell in your spreadsheet where you want the number sequence to begin, ensuring there is enough space below it for 20 rows.

Solution 1Recommended

Use the SEQUENCE Function (Recommended for Newer Versions)

The fastest method for Excel 2021 and Microsoft 365 users to automatically generate a numeric sequence.

The SEQUENCE function is a dynamic array formula that automatically spills numbers into adjacent cells, making it the most efficient way to generate long lists.

Select the starting cell

Click on the specific cell in the column where you want the sequence to start (for example, cell A2).

Enter the SEQUENCE formula

Type =SEQUENCE(20) directly into the cell or the formula bar.

Apply the formula

Press the Enter key. The column will automatically fill downwards with numbers 1 through 20.

Use the SEQUENCE Function (Recommended for Newer Versions)

Dynamic Arrays: If you need the numbers to go horizontally across a row instead, you can format the formula as =SEQUENCE(1, 20).

Solution 2

Use an Addition Formula and Fill Handle

A universally compatible method that works in all versions of Excel, including older editions.

Solution 3

Use the AutoFill Feature (No Formulas)

Quickly generate a list by manually establishing a pattern and dragging, requiring no mathematical formulas.

Powerful Spreadsheet Tool

Easily Generate Number Sequences in WPS Spreadsheet

WPS Spreadsheet provides intuitive tools like the Fill Handle and advanced functions like SEQUENCE, making it simple to create numbered lists, manage data, and perform complex calculations for free.

1. Open WPS Spreadsheet: Launch WPS Office and create a new blank spreadsheet or open an existing workbook.
2. Select your cell: Click on the cell where you want the number sequence to begin.
3. Apply the SEQUENCE function: Type =SEQUENCE(20) into the formula bar and press Enter to instantly populate the list.
4. Alternative AutoFill: Alternatively, type 1 and 2 in the first two cells, highlight them, and drag the Fill Handle down to row 20.

Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Built-in Fill Handle and advanced array functions for lightning-fast data entry.Lightweight, ad-free experience with a familiar ribbon interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the SEQUENCE function returning a #NAME? error?

This error occurs if you are using an older version of Excel (like Excel 2016 or 2019) that does not support dynamic array functions. If you see this error, use the AutoFill method or the addition formula (=A2+1) instead.

Can I start the sequence from a number other than 1?

Yes. If using the SEQUENCE function, you can add parameters, such as =SEQUENCE(20, 1, 5) to output 20 rows starting at the number 5. With AutoFill, just type your preferred starting number (like 5) and the next number (like 6) before dragging the selection.

How do I fill numbers in steps of 2 or more?

Using the SEQUENCE function, the fourth parameter dictates the step size. For example, =SEQUENCE(10, 1, 2, 2) creates 10 rows starting at 2, increasing by 2 each time. With AutoFill, type your first two numbers (e.g., 2 then 4), select both, and drag down.

Excel & Data Problems