Function Problems

How to Fill an Excel Column with Sequential Numbers Without Dragging

Tauseeq Magsi Oct 22, 2026 868 views

Question details

The user needs to generate thousands of sequential numbers in an Excel column quickly without manually dragging the fill handle.

How to Fill an Excel Column with Sequential Numbers Without Dragging

Product: Spreadsheet
Device & OS: not provided
Scenario: Working with a massive dataset where dragging the mouse to auto-fill thousands of row numbers is tedious and inefficient.
Observed behavior: The user wants an automated formula or tool to generate a long sequence of row numbers instantly.

Before you start

Determine the exact number of sequential rows you need to generate before typing your formula, and ensure the cells below your starting point are completely empty.

Solution 1Recommended

Use the SEQUENCE Function to Auto-Fill Numbers

The fastest way to generate a massive vertical list of sequential numbers is by using the SEQUENCE function, which automatically spills the calculated results down the column.

The SEQUENCE function is a dynamic array formula. By simply defining how many rows you need, it does the heavy lifting instantly without requiring you to click and drag your mouse.

Select your starting cell

Click on the first empty cell in the column where you want your sequential numbers to begin.

Enter the SEQUENCE formula

Type =SEQUENCE(14000,1,1,1) into the cell, replacing 14000 with the actual number of rows you want to generate. Press the Enter key to let the results spill down the column.

Convert the dynamic formula to static values (Optional)

If you need permanent numbers rather than a formula, select the entire generated range and copy it (Ctrl + C). Then, right-click the first cell of the sequence, select 'Paste Special', and choose 'Values'.

Use the SEQUENCE Function to Auto-Fill Numbers

SEQUENCE Syntax Tip: The full syntax is =SEQUENCE(rows, [columns], [start], [step]). If you just want a basic numbering list starting at 1, you only need to provide the rows argument, such as =SEQUENCE(14000).

Solution 2

Use the Fill Series Feature

If you are using an older version of Excel that does not support the SEQUENCE function, the built-in Fill Series tool is the best alternative for generating numbers without dragging.

Work Faster with WPS Office

Easily Generate Sequential Data in WPS Spreadsheet

WPS Spreadsheet fully supports dynamic array functions like SEQUENCE, allowing you to instantly generate massive lists of numbers. It features a familiar interface, making data entry and formatting exceptionally fast.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
2. Select the target cell: Click the topmost cell of your intended numbering column.
3. Apply the dynamic formula: Type =SEQUENCE(number_of_rows) and hit Enter.
4. Paste as values if required: Copy the newly generated list and use Paste Special > Values to lock in the numbers permanently.

100% compatible with Microsoft Excel (.xlsx) file formatsFully supports advanced dynamic array formulas like SEQUENCEFree, lightweight, and loads massive datasets quicklyFamiliar user interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can I start the sequential numbers from a specific number other than 1?

Yes, you can change the third argument in the SEQUENCE function to set your custom starting point. For example, using =SEQUENCE(100, 1, 50, 1) will generate 100 numbers starting from 50.

How do I generate numbers with a specific interval or step?

You can adjust the fourth argument in the SEQUENCE function, which defines the step. For example, =SEQUENCE(10, 1, 1, 5) generates 10 numbers starting from 1 with an interval of 5, resulting in 1, 6, 11, 16, etc.

Why is my SEQUENCE formula displaying a #SPILL! error?

The #SPILL! error occurs when there is existing data, spaces, or merged cells blocking the formula from expanding downwards. You must clear the cells below the formula so it has enough empty room to spill the results.

Does the SEQUENCE function update automatically if I insert new rows?

The SEQUENCE function generates a fixed number of rows based on the number you provided in the formula. If you manually insert blank rows into the middle of the spilled data, it will trigger a #SPILL! error. To make it dynamic based on data in another column, you can combine it with the COUNTA function, like =SEQUENCE(COUNTA(B:B)-1).

Excel & Data Problems