Excel Not Filling Sequential Numbers? Fix the Series

If Excel repeats a number instead of counting, enter the first two numbers, select both cells, and drag the fill handle down or across; Excel uses the gap between them to continue the series. For a controlled sequence, use Home > Fill > Series, or enter a formula that adds 1 to the previous cell.

How Excel decides what to fill

Excel’s fill handle can copy a value, extend a pattern, or continue a series. What it does depends on the selection. If you drag a single cell containing 1, Excel may copy 1 into the cells you cross. If you select cells containing 1 and 2 first, Excel recognizes a step of 1 and continues with 3, 4, 5, and so on. With 1 and 3 selected, it can infer a step of 2 and continue 5, 7, 9.

To start a basic sequence, type 1 in A1 and 2 in A2, select A1:A2, then drag the small square at the lower-right corner of the selection. That square is the fill handle. Drag down for a column or right for a row. Excel previews the continuation as you drag; release the mouse button when the preview reaches the required cell.

This behavior explains a common misconception: dragging one number does not always mean “count upward.” Excel cannot infer a step from one value, so it often treats the action as copying. Give it two examples or use a command that specifies the step.

Quick checks when the fill handle does not work

If you cannot see or drag the fill handle, check whether it is enabled. In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Under Editing options, select Enable fill handle and cell drag-and-drop, then click OK. If that option was turned off, the small square will not appear at the corner of the selected cell or range.

Then check the selection and the drag itself. The pointer needs to be over the small square at the bottom-right of the selected range, not over the cell border or its contents. Select the starting values together before dragging, and make sure the destination cells are not blocked by merged cells or protected-sheet restrictions. If the sheet is protected, you may not be allowed to change the destination cells.

It repeats one value: select two starting values that show the intended step, such as 1 and 2.
It fills the wrong direction: start with a selection that makes the pattern clear and drag in the desired direction.
Nothing fills: check the fill-handle setting, sheet protection, merged cells, and whether the destination range can be edited.
The result looks like numbers but will not calculate: check whether the entries are stored as text, particularly if they came from an import or have a leading apostrophe.

A double-click on the fill handle can fill downward alongside a neighboring column of data. It is useful for extending a formula or series through a data list, but the neighboring data should be continuous; a blank in that column can affect how far Excel fills.

Use Fill Series for an exact step or endpoint

When dragging is awkward or you need a precise increment, use the Series command. For example, to fill A1:A10 with 1 through 10, enter 1 in A1, select A1:A10, then choose Home > Fill > Series. In the dialog, choose Columns and Linear, set Step value to 1, and click OK. The selected range is filled with consecutive numbers.

The Series dialog is also useful for numbers that do not increase by one. To create 10, 15, 20, 25, enter 10 as the starting value, select the destination range, and use a Linear series with a step value of 5. A stop value can limit the series, but the selected range also determines how many cells can be filled. For a date sequence, choose Date and the appropriate date unit, such as Day, Weekday, Month, or Year, rather than treating dates as ordinary increments.

On Windows, the ribbon route is Home > Fill > Series. The layout of the dialog can vary slightly across Excel releases. In Excel for Mac, the ribbon and menu arrangement may differ by build; look for Fill and Series on the Home tab. In Excel for the web, available commands can differ from the desktop app, so dragging two example values or using a formula may be the simpler option.

Generate numbers with a formula

Formulas are useful when the sequence should update as you add rows or when you want the numbering logic to be explicit. With the first value 1 in A2, put the following formula in A3 and fill it down. Each row adds one to the value immediately above, so A3 returns 2, A4 returns 3, and A5 returns 4.

With 1 in A2 and the next number to be calculated in A3, use: =A2+1

A row-based formula can produce numbering from a chosen starting row without relying on the previous cell. With the sequence beginning in A2, enter this formula in A2 and copy it down. A2 returns 1, A3 returns 2, and A4 returns 3.

With the first number in A2 and numbering intended to start at 1 on worksheet row 2, use: =ROW()-1

In Excel for Microsoft 365 or Excel 2021, the SEQUENCE function can create a whole list from one formula. With A2:A11 empty and the list intended to start in A2, enter the formula below in A2. It spills the numbers 1 through 10 into the ten cells. If any cell in the spill area is occupied, Excel displays a spill error until that area is cleared.

With the destination range A2:A11 empty, use: =SEQUENCE(10)

SEQUENCE can also take arguments for the number of rows, columns, starting value, and increment. For example, when A2:A6 is empty and you want five values starting at 10 in steps of 5, enter this in A2. It returns 10, 15, 20, 25, and 30. SEQUENCE is available in Microsoft 365 and Excel 2021; older Excel versions can use the fill handle, Series command, or a copied formula instead.

With A2:A6 empty and the first value 10 and step 5 required, use: =SEQUENCE(5,1,10,5)

Check whether the entries are numbers or text

A value that looks like 1 may be stored as text. This can happen after importing a CSV file, pasting data from another system, entering a leading apostrophe, or applying a text format before typing. Text values may not behave like numeric starting values when Excel tries to extend a series, and arithmetic formulas can return an error if they refer to text that cannot be converted.

Look for an error indicator in the cell or check the source data and number format. Changing a cell’s format to General or Number does not always convert text that is already stored in it; it may only change how future entries are displayed. Depending on the data, you can re-enter the values, use the warning menu’s conversion option when Excel offers it, or clean the imported column before filling. Preserve leading zeros when they are meaningful identifiers, such as product codes or postal codes: those are often better treated as text than as numbers to increment.

Also distinguish a number sequence from a formatted label. If a cell contains text such as Item 1, Excel may copy it rather than create Item 2. For labels that must increment, keep the numeric part in its own column and combine it with the label only when needed, or use a formula designed for the desired output.

Dates, gaps, and more complicated patterns

Dates are stored as serial numbers in Excel, but the fill tools can recognize date patterns. If you drag a single date, the result may advance by days; if you need weekdays, months, or years, use Home > Fill > Series and select Date with the appropriate unit. Check the displayed dates after filling, since the cell’s number format controls whether a serial value appears as a date or as a number.

For a sequence with a gap, provide two examples that reveal it. Starting with 100 and 110 tells Excel to continue in increments of 10. If your required pattern is irregular, such as 2, 4, 8, 16, the fill handle may not infer the intended rule reliably. Use a formula that expresses the rule, fill a deliberately prepared set of values, or enter the sequence explicitly and verify it.

Numbering rows in a list is different from creating a permanent record ID. A formula based on ROW changes according to worksheet position, so sorting or inserting rows can change the displayed numbering. If an identifier must remain attached to the same record after sorting, assign and preserve IDs as values rather than relying on a row-position formula. Similarly, formulas that simply count every row do not automatically skip filtered-out records; visible-row numbering needs a method designed for filtered lists.

Windows, Mac, and web differences

The core pattern is the same across desktop versions: enter two values, select them, and extend the fill handle. On Windows, Ctrl+D fills down from the top cell of a selected range; the ribbon equivalent is Home > Fill > Down. In Excel for Mac, Command+D is the usual Fill Down shortcut. Shortcuts can vary with keyboard layout and Excel release, so the ribbon command is a reliable alternative.

Excel for the web supports common spreadsheet editing, but some desktop dialogs and settings may be presented differently or may not be available in the same way. If you cannot find a particular Series option in the web interface, create the sequence with two starting values or a formula, or open the workbook in the desktop app. Dynamic-array formulas such as SEQUENCE also require a version that supports them; they are not a dependable choice for a workbook that must be opened in older Excel releases.

Frequently Asked Questions

Why does Excel copy 1 instead of filling 1, 2, 3?
Select two cells containing 1 and 2 before dragging the fill handle. One value alone does not tell Excel what increment you want, so it may copy that value.

How do I make Excel count by 5?
Enter two starting values five apart, such as 5 and 10, select both, and drag. Or use Home > Fill > Series with a Linear series and Step value of 5.

Can I fill numbers without dragging?
Yes. Use Home > Fill > Series to specify the step and range, or fill down a formula such as =A2+1 when A2 contains the starting number.

Why is my fill handle missing?
In Excel for Windows, check File > Options > Advanced and make sure Enable fill handle and cell drag-and-drop is selected. Also check whether the worksheet is protected or the cells are merged.

How do I number rows automatically?
For numbering based on worksheet position, enter =ROW()-1 in A2 and copy it downward. The formula assumes numbering begins on row 2; use a different adjustment if your first numbered row is elsewhere. Remember that row-based numbers can change when rows are inserted or rearranged.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.