Create a Number List in Excel: Easy Steps and Methods

How-to basics · Updated November 20, 2026

To create a numbered list in Excel, enter 1 in the first cell and 2 in the cell below it, select both cells, then drag the fill handle down. Excel continues the pattern. For a list that should update automatically, enter a formula such as =SEQUENCE(10) in a blank cell; it returns the numbers 1 through 10 in Microsoft 365 and Excel 2021 or later.

The fill handle is a quick choice for a fixed list, while a formula is useful when you want numbering to recalculate or spill into a set number of rows. The steps below focus on Excel for Microsoft 365 on Windows. The same fill-handle approach works in Excel for Mac and Excel for the web, although ribbon placement can vary slightly.

What You’ll Need

  • An Excel worksheet with a blank column or range where the numbers can go.
  • A plan for the list: its starting number, increment, and approximate length. For example, you might need 1, 2, 3 or 10, 20, 30.
  • For a formula-based list, Microsoft 365 or Excel 2021 or later if you want to use the SEQUENCE function. Older versions can use the fill handle or a simple incrementing formula.

Step-by-Step

  1. Choose where the list will begin. Click the first cell in the intended column, such as A2 if row 1 contains a heading. Keep the cells beneath it clear if you plan to use a formula that fills several cells at once. If the list will sit beside names or other records, make sure the first number lines up with the first record.
  2. Create a basic sequence with the fill handle. Type 1 in A2 and 2 in A3, then select A2:A3. Move the pointer to the small square at the lower-right corner of the selection. When the pointer becomes a plus sign, drag down to the last row you need. Release the mouse button; Excel continues the pattern as 3, 4, 5, and so on. Selecting two starting numbers tells Excel the interval, so this method works for other patterns too.
  3. Make a sequence with a different interval. Enter the first two values that show the pattern you want. For example, type 5 in A2 and 10 in A3, select both cells, and drag the fill handle down. Excel extends the list by five each time: 15, 20, 25, and so on. For a descending sequence, enter the larger number first and a smaller number second, such as 10 and 9, then drag down.
  4. Use the Series command when you know the endpoint. Enter the starting number in the first cell, select the range you want to fill, and choose Home > Fill > Series. In the Series dialog, select Columns for a vertical list, choose Linear, and set Step value to the amount to add each time. Enter a Stop value, then select OK. For example, with a starting value of 1, a step of 1, and a stop value of 25, Excel fills the selected column with consecutive numbers up to 25. If the selected range is shorter than the requested series, Excel can only fill the selected cells.
  5. Fill down with a simple formula. This is useful when you already have a first number and want the next row to add one. Put 1 in A2. With 1 in A2 and the next number intended for A3, enter =A2+1 in A3. Press Enter, select A3, then drag its fill handle down. Excel adjusts the reference in each row, producing 2, 3, 4, and onward. To change the increment, replace 1 in the formula with another number, such as =A2+5 for steps of five.
  6. Generate a list with SEQUENCE. With A2 as the first cell and A2:A11 empty, enter =SEQUENCE(10) in A2 and press Enter. Excel spills the values 1 through 10 down the column. SEQUENCE uses the format =SEQUENCE(rows,columns,start,step). For example, with A2:A6 clear and A2 as the output cell, =SEQUENCE(5,1,10,2) returns 10, 12, 14, 16, and 18. The first argument sets the number of rows, the second sets the number of columns, the third sets the starting value, and the fourth sets the increment. You can leave optional arguments out when the default of one column, a start of 1, and a step of 1 is appropriate.
  7. Check the result and save the workbook. Confirm that the last value, direction, and interval match what you intended. If the numbers label records, check that each number is beside the correct row. Save with Ctrl+S on Windows or Command+S on Mac. A number list is stored as cell values or formulas, so saving preserves the method you chose.

If you use Excel for Mac, you can enter values and drag the fill handle in the same way. The Series command is also available from the Home tab, though ribbon layout may differ by version. Excel for the web supports fill-handle autofill and SEQUENCE in supported accounts, but its ribbon and dialog options may not match the Windows desktop app exactly.

Common Mistakes

Dragging a single number and getting copies: When you drag one selected cell, Excel may copy that value instead of counting upward. Enter two consecutive values, select both, and drag to establish the interval. If you are using a formula, make sure it refers to the cell immediately above rather than repeatedly pointing to the original value.

Selecting the wrong starting cells: Excel infers the pattern from the selected values. If you select 1 and 3, the next values increase by two; if you accidentally include a heading or unrelated value, the result can be unexpected. Select only the intended seed cells before dragging.

Typing numbers as text: A number stored as text may not behave as expected in calculations, sorting, or formula-based sequences. Look for a warning indicator or a left-aligned value, and check the cell format if the series will be used in calculations. For ordinary numbering, enter numeric values in cells formatted as General or Number.

Overwriting existing data: A fill-handle drag can replace cells in the destination range. Check that the cells below the starting values are empty or that you are comfortable replacing their contents before you drag.

Expecting formulas to renumber every situation automatically: A formula such as a reference to the previous row creates a sequence, but inserted, deleted, or sorted rows can affect how labels align with records. After changing the table structure or sorting, verify the numbering against the data rather than assuming it still represents the intended order.

Tips

Use the Series dialog for a precise endpoint. It is a handy option when you know the start, step, and stopping value but do not want to estimate how far to drag. For instance, a step of 10 and a stop of 100 can create 10, 20, 30, and so on, provided the starting value and selected direction match the intended pattern.

Keep numbering separate from record data. Put identifiers in their own column and avoid manually renumbering only part of a table. After adding or removing records, check that the labels still match the rows. If the numbers are just visual row labels, you can regenerate them; if they are permanent IDs used elsewhere, changing them could cause confusion.

Show leading zeros without changing the numeric value. If a list should display as 001, 002, 003, select the cells, press Ctrl+1 on Windows, choose Number > Custom, and enter 000 in the Type box. On Mac, Command+1 opens Format Cells. This is a display format: the underlying values remain 1, 2, and 3, which can still be used in calculations. If the zeros must be part of a text identifier, format the cells as Text before entering the values instead.

Use a table carefully. If the list is part of an Excel table, adding rows can extend formulas or formatting, but a manually filled series may not automatically produce the numbering you expect. Review the numbering after adding records, especially if the column is meant to reflect the current row position.

Choose a method that suits the job. The fill handle is simple for a short, fixed list. The Series dialog is convenient for a known stopping value or interval. A formula is useful if you want the sequence to depend on worksheet values, while SEQUENCE is concise when you want a specific number of results and have a compatible Excel version.

Troubleshooting

The fill handle is missing: In Windows desktop Excel, open File > Options > Advanced. Under Editing options, make sure Enable fill handle and cell drag-and-drop is selected. Select OK and return to the worksheet. On Mac, check Excel > Preferences or Settings for editing options; the exact label and location can vary by release. In Excel for the web, use the desktop app if you need a setting that is not available in the browser.

The drag repeats the same value: Undo with Ctrl+Z on Windows or Command+Z on Mac if the fill changed the cells incorrectly. Then enter the first two values in the desired pattern, select both, and drag again. If the source is a formula, inspect it in the formula bar to confirm it increments the previous row.

SEQUENCE returns a spill error: The cells where the results need to appear may contain data, merged cells, or another obstruction. Clear the intended output range, unmerge any cells in that range if appropriate, and enter the formula again in its top-left cell. Check that the number of requested rows and columns fits within the worksheet.

The formula appears as text instead of calculating: Change the cell format to General, then re-enter the formula. Also check that the first character is an equals sign and that Show Formulas is not turned on. On Windows, Ctrl+` toggles formula display; on many Mac keyboards, Control+` is the equivalent, though the key combination can vary with keyboard layout. If only one formula is visible, the cell may have been formatted as Text before the formula was entered.

The numbers skip, go backward, or stop too soon: Review the seed values or the Series dialog settings. The difference between the first two selected values determines the fill-handle interval. In the Series dialog, check the Step value, Stop value, and whether Columns is selected for a vertical list. If you dragged over only a few cells, extend the fill to the required range.

The list will not extend because cells are occupied: Decide whether the existing values should be kept. Move or clear them before filling, or select a different empty range. Do not overwrite neighboring data unless you have confirmed it is safe to replace.

Frequently Asked Questions

How do I make Excel number rows automatically?

For a fixed list, enter 1 and 2 in the first two cells, select them, and drag the fill handle. For a spilling list in Microsoft 365 or Excel 2021 or later, enter =SEQUENCE(20) in the first cell to return 1 through 20, provided the cells below are clear.

Why does Excel copy 1 instead of continuing 2, 3, 4?

Excel often copies a single value when you drag one cell. Give it a pattern by entering 1 and 2 in adjacent cells and selecting both before dragging. You can also use Home > Fill > Series and set a step value of 1.

Can I start a number list at a number other than 1?

Yes. For the fill handle, enter the starting number and the next number in the pattern, such as 50 and 51, then select both and drag. With a compatible version of Excel, put the formula in an empty starting cell and enter =SEQUENCE(8,1,50,1) to return eight values from 50 through 57.

How do I number a list by tens or hundreds?

Enter two values that show the interval, such as 10 and 20, select them, and drag. Or use the Series dialog with a Step value of 10. In Excel 2021 or Microsoft 365, =SEQUENCE(10,1,0,100) returns ten values from 0 to 900, increasing by 100 each time.

Can I create a numbered list in Excel for the web?

Yes. Enter the first two numbers, select both, and drag the fill handle to extend the series. SEQUENCE is available in supported web versions as well. If you cannot find a desktop-only setting or command, open the workbook in the Windows or Mac app.

How do I show 001 instead of 1?

Format the cells with a custom number format of 000 to display three digits while retaining numeric values. Use Ctrl+1 on Windows or Command+1 on Mac, then choose Number > Custom. If the zeros are part of a text code rather than a number, format cells as Text before typing.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.