How to Insert a Number List in Excel

To insert a sequential number 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 more control, use Home > Fill > Series, or use a formula if the numbers should adjust to their row positions. These steps are for Excel for Microsoft 365 on Windows.

Excel does not have the same one-click numbered-list button found in a word processor. The usual approach is to put one number in each worksheet cell, next to the corresponding item or record. If you mean a numbered list of lines inside one cell, see the note in Tips.

What You’ll Need

An Excel workbook with a worksheet where you want the list to appear.
A blank column or range for the numbers. If each number labels an item, leave a neighboring column for the item names or details.
A starting number and, if you are using the fill command, an ending number or a clear idea of how many entries you need.

You do not need to install an add-in or enable a special setting. Save the workbook before making larger changes, especially if the list is part of a table that contains important data.

Step-by-Step

Choose where the numbers will go. Click the first cell in the column or range intended for numbering. For example, if row 1 contains headers and the list starts on row 2, use A2 for the first number and put any item associated with it in B2. Keeping the number and its item in separate cells makes the list easier to sort, filter, and update. If you already have data, insert or choose a dedicated number column rather than typing over it.
Enter the first two numbers. Type 1 in the first cell and 2 in the cell directly below it, pressing Enter after each entry. The pair tells Excel that the pattern increases by one. For another starting point or step, enter two values that show the pattern you want: for example, 5 and 10 creates a sequence that increases by 5. Check that the values are numbers, not text; numbers are usually aligned to the right by default.
Select both starting cells. Click the first cell, then drag through the second so the two cells are highlighted together. Selecting only the first cell can make Excel copy the same number rather than continue a sequence. Using two starting values is the most reliable way to show Excel the intended interval before filling a longer list.
Drag the fill handle to extend the list. Move the pointer to the tiny square at the lower-right corner of the selected range. When the pointer becomes a small black cross, drag down to the last row you need, then release. Excel should fill the selected cells with 3, 4, 5, and so on. If you need 20 entries starting in row 2, extend the selection through row 21; the first two numbers are already included in that range.
Check the last number and the neighboring data. Review the top, middle, and bottom of the filled range to confirm the count and pattern. For a list from 1 through 20, the last number should be 20. Check that each number sits beside the intended item and that the drag did not extend into unrelated rows. If the result is wrong, use Ctrl+Z on Windows to undo immediately, then repeat the fill with both starting cells selected.
Use Fill Series when you want an exact range. Enter the first number, select the cells to fill, and choose Home > Fill > Series. In the Series dialog, choose Columns for a vertical list or Rows for a horizontal one. Choose Linear for a regular number sequence, enter a Step value such as 1, and set a Stop value such as 50. Click OK. Excel fills the selected direction using those settings, so you can create a sequence without dragging precisely to the final cell. If the dialog is not available in your version or layout, use the fill handle instead.
Use a formula for row-based numbering. If row 1 contains a heading and the numbered list begins in A2, enter =ROW()-1 in A2. The formula returns 1 in row 2; copy it down by dragging the fill handle or copying and pasting it into the rows below. The number is calculated from the cell’s row position, so it updates when the formula is copied to another row. If your list begins on row 5, use =ROW()-4 in the first numbering cell so that row 5 returns 1. Use a formula when row position should determine the number; use typed values when the numbers should remain fixed regardless of row changes.
Decide whether to keep formulas or numbers. Formula-generated numbering recalculates, which is useful if you add or remove rows. If you need a fixed snapshot, select the numbered cells, copy them, then use Home > Paste > Paste Values. This replaces the formulas with their current displayed results. Before converting, verify the sequence because the formulas will no longer update after pasting values.
Format the list if needed. Select the number cells and use the Home tab to change the font, alignment, or number format. Simple integers normally need no special format. If you see leading zeros or an unexpected date, check the cell format and the way the values were entered. Formatting changes how a value appears; it does not by itself create a sequence.

On Mac, the fill handle works in much the same way; use Command+Z to undo instead of Ctrl+Z. Excel for the web also supports filling with the handle, though ribbon options and dialog availability can differ from desktop Excel. If a command is missing in the web version, use the two-value fill method or copy a formula down.

Common Mistakes

Selecting just one starting cell: Dragging from a single cell containing 1 can repeat 1, depending on the fill action. Enter 1 and 2 and select both before dragging to make the intended sequence explicit.
Filling too far or not far enough: The fill handle follows the range you drag across. Use row numbers at the left of the worksheet to check the final destination, and verify the last value rather than assuming the fill ended where intended.
Sorting only the number column: This separates numbers from their associated names or records. Select the whole data range before sorting, or use Excel’s sort controls on the table so each row stays together.
Typing numbers that Excel treats as text: Text numbers may not fill, sort, or calculate as expected. A leading apostrophe, imported data, or a Text cell format can cause this. Check alignment and the warning indicator, then convert the values to numbers if appropriate.
Expecting typed numbering to update automatically: A filled series is made of fixed values. Inserting or deleting a row does not reliably renumber the remaining values. Use a row-based formula if the numbers need to reflect their current positions.
Using formatting to create numbers: A custom number format can display values with extra digits, but it cannot generate missing entries. First create the actual sequence, then apply formatting if you want a particular appearance.

Tips

Use a table for a growing list. Select the data and choose Insert > Table, making sure the range includes the number and item columns. Tables make filtering and sorting easier and automatically extend when you add rows. A typed series will not necessarily renumber itself when the table grows, so decide whether fixed numbering or formula-based numbering suits your workflow.
Use a non-one step when needed. Starting with 10 and 20 tells Excel to continue 30, 40, and so on. For a countdown, enter 10 and 9 before filling. For a horizontal list, enter the first two values in neighboring cells across a row, select both, and drag the handle to the right.
Use the double-click fill handle for a long list beside data. If the adjacent column has a continuous block of entries, double-click the fill handle after selecting the starting number cells. Excel may fill down to match the neighboring block. This can save time, but it uses nearby data to decide where to stop, so inspect the last filled row and avoid relying on it when the adjacent column has gaps.
Keep numbering separate from item text. Separate columns make it easier to filter, sort, edit, and reuse the list. Combining a number and a name in one cell can make later analysis less convenient.
For several numbered lines inside one cell, insert line breaks manually. Type a number and text, press Alt+Enter on Windows to start another line in that cell, then type the next number. Turn on Home > Wrap Text if the lines are not visible. On Mac, the line-break shortcut can vary by keyboard and Excel version; try Control+Option+Return. This creates text inside one cell, not a sortable sequence of separate records.
Use meaningful labels when sharing the workbook. A header such as ID or Item No. makes the purpose of the number column clear. If the numbers are just display order rather than permanent identifiers, make that distinction clear to other users.

Troubleshooting

The same number repeats instead of increasing. Undo the fill, enter two consecutive starting values, select both cells, and drag again. If you used Fill Series, check that Linear is selected and that the Step value is correct. A step of 0 repeats the same value; a step of 1 increases by one.

The fill handle is missing. Check Excel’s fill-handle setting: choose File > Options > Advanced, then under Editing options make sure Enable fill handle and cell drag-and-drop is selected. The File > Options path applies to Windows desktop Excel; settings can be arranged differently on Mac and are more limited in Excel for the web. You can still copy the starting cells, select the destination range, and paste, or use Home > Fill > Series where available.

The formula displays as text or does not calculate. Confirm the entry begins with an equals sign and that the cell is not formatted as Text. Change the format to General, then re-enter the formula by selecting the cell, pressing F2, and pressing Enter. Also check that Show Formulas is not turned on; press Ctrl+` on Windows to toggle it. The Mac shortcut and key layout may differ, so use the Formulas tab’s Show Formulas control if necessary.

The sequence has gaps or the count is wrong. Compare the first and last values and count the rows in the selected range. If the sequence should be continuous but a row was skipped, fill that missing cell or recreate the whole range. If some rows are intentionally blank, decide whether numbering should continue across them or count only populated items; a simple row-based formula counts worksheet rows, including blanks.

Numbers become dates or show unexpected digits. Select the affected cells and choose Home > Number Format, then select General or Number. If the entered values have already been interpreted as dates, changing the format may not restore the original input; undo and enter the values again in cells formatted as General. For codes that require leading zeros, use a suitable number format or store them as text, knowing that text is not ideal for arithmetic.

Frequently Asked Questions

How do I make Excel number a list automatically?

For a quick sequence, enter 1 and 2 in the first two cells, select them, and drag the fill handle. For numbering that should respond to row positions, enter a row-based formula in the first list cell and copy it down. The fill method creates fixed numbers; formulas recalculate.

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

Yes. Enter the starting value and the next value that establishes the step. For example, enter 25 and 26, select both, and fill down to continue by ones. In the Series dialog, set the starting value and Step value directly.

How do I number only rows that contain an item?

A basic row-based formula counts every worksheet row, including blank item rows. If blank rows should remain unnumbered, use a formula designed to test the neighboring item cell, or fill numbers only across the rows that contain entries. Check the result after adding or removing items so the numbering still matches your intended list.

Will Excel renumber items after I sort the list?

Sorting the entire range keeps each number with its associated item, but fixed numbers may then appear out of order. If the number should show the item’s new position, use a row-based formula and sort the complete range. Never sort only the number column, because that can detach the numbers from their records.

Can I create a numbered list inside one cell?

Yes, but it is text rather than a set of separate spreadsheet records. Type each line in the same cell using Alt+Enter on Windows to insert line breaks, and enable Wrap Text. For a list you need to sort, filter, or calculate with, put each item on its own worksheet row instead.

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.