# Automatically number rows in Excel

Whether it’s for preparing revenues or customer lists, continuous numbering improves the clarity of Excel tables. Although Excel does not provide a button for automatic numbering, it’s easy to automatically number rows once you know how to. The following guide explains how to use Excel’s **simple options** to add numbering.

## Auto numbering in Excel – what are the options?

Excel provides two options for automatic numbering to help make tables easier to read. On the one hand, you have the option to create continuous or user-defined number sequences with the **fill box**. On the other, the **ROW function** lets you define numbering as part of a formula.

### Method 1: Auto numbering with fill boxes

The **fill box or auto-fill box** can be found at the bottom right edge of a cell when you move your mouse cursor over it. To select multiple cells, click on the area inside a cell and drag the box down – without clicking on the little fill box at the bottom right edge.

[![Image: Fill box in an Excel cell](https://www.ionos.com/digitalguide/fileadmin/_processed_/6/1/csm_fill-box-in-an-excel-cell_fe4c43ab0f.webp "Fill box in an Excel cell")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/fill-box-in-an-excel-cell.png) Fill box in an Excel cell The fill box is the easiest way to add auto numbering to rows in your Excel table. Here, you have the option to set the sequence the numbering should adopt.

**Step 1**: If you prefer **ascending numbering** (1, 2, 3, 4, …), simply enter “1” and “2” in the first two cells of the column. Excel always needs **2 or 3 numbers** to automatically detect and continue a desired sequence. Select the range with the numbers. When you select the range, make sure you don’t click on the little green square at the bottom right of the cell. Instead, click in the cell and drag the frame to the end of the corresponding cell.

[![Image: Selecting the range with numbering](https://www.ionos.com/digitalguide/fileadmin/_processed_/e/f/csm_selecting-the-range-with-numbering_cff7d24a25.webp "Selecting the range with numbering")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/selecting-the-range-with-numbering.png) Selecting the range with numbering **Step 2**: Now, move the cursor to the **little green box** in the bottom right edge of the cell. Drag this down to the end of the area in which you’d like numbering to appear.

[![Image: Select multiple cells with the fill box](https://www.ionos.com/digitalguide/fileadmin/_processed_/d/a/csm_select-multiple-cells-with-the-fill-box_b0d3b735fa.webp "Select multiple cells with the fill box")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/select-multiple-cells-with-the-fill-box.png) Select multiple cells with the fill box **Step 3**: Excel will now complete the **continuous** number sequence.

[![Image: Excel will now automatically number the cells](https://www.ionos.com/digitalguide/fileadmin/_processed_/5/c/csm_excel-will-now-automatically-number-the-cells_1ebf9dc190.webp "Excel will now automatically number the cells")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/excel-will-now-automatically-number-the-cells.png) Excel will now automatically number the cells You can also insert numbering for odd numbers or in steps of 10, 20, or 100, for example. To do this, simply enter the **number sequence** you wish to use. Excel will take care of the rest.

[![Image: Numbering in different steps](https://www.ionos.com/digitalguide/fileadmin/_processed_/b/8/csm_numbering-in-different-steps_9aa5d4355e.webp "Numbering in different steps")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/numbering-in-different-steps.png) Numbering in different steps  Tip You can also use auto numbering to auto-complete date entries or times, for example. But you always need to provide the first 3 to 3 numbers for Excel to recognize a number sequence or pattern. Only then does the program automatically detect the sequence.

### Method 2: Add numbering with the ROW function

As an alternative to the fill box, you can use the ROW function to add automatic numbering in Excel. The ROW function syntax is as follows:

```none
=ROW([CELL REFERENCE])
```

The ROW function returns the **row number of the reference**, which is entered in brackets “()”. Add “B5” into the formula, for example.

```none
=ROW(B5)
```

Now press \[Enter\]. The function will return “5,” since it refers to row 5 in column B.

[![Image: Using the ROW function](https://www.ionos.com/digitalguide/fileadmin/_processed_/9/6/csm_using-the-row-function_68a7076c23.webp "Using the ROW function")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/using-the-row-function.png) Using the ROW function  Note Remember that you define the cell reference. If you leave the reference empty, the ROW function will automatically output the number of the cell that contains the formula.

Now, you can use the ROW function to insert automatic numbering.

**Step 1**: In the first cell, enter the ROW function with the starting cell reference. If you begin automatic numbering in cell A1, enter “=ROW(A1)”.

[![Image: ROW function numbering](https://www.ionos.com/digitalguide/fileadmin/_processed_/d/b/csm_row-function-numbering_1c963e1bc8.webp "ROW function numbering")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/row-function-numbering.png) ROW function numbering Press \[Enter\]. A “1” will now appear in cell A1.

[![Image: The ROW function outputs the first number](https://www.ionos.com/digitalguide/fileadmin/_processed_/d/7/csm_the-row-function-outputs-the-first-number_a7308ab089.webp "The ROW function outputs the first number")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/the-row-function-outputs-the-first-number.png) The ROW function outputs the first number **Step 2**: Now drag the fill box to the end of the desired area. The ROW function will then insert continuous numbering.

[![Image: ROW function adds automatic numbering](https://www.ionos.com/digitalguide/fileadmin/_processed_/b/c/csm_row-function-adds-automatic-numbering_8f435b272f.webp "ROW function adds automatic numbering")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/row-function-adds-automatic-numbering.png) ROW function adds automatic numbering  Note If you change the data or move or delete rows after adding the ROW function, the numbering may be interrupted. To update it, select two of the existing numbers of the numbering sequence and drag the fill box across the interrupted area.

**Step 3**: Would you like the ROW function with number 1 to begin **in a different row**? This is easy to do: Click on the cell where numbering should start, e.g. B3. Enter the ROW function and then **subtract the rows** that remain empty above the start of the numbering sequence. The syntax is as follows:

```none
=ROW([CELL REFERENCE])-[NUMBER OF CELLS]
```

The ROW function will now start your numbering sequence with “1” in row B3, since B1 and B2 are subtracted from the numbering:

[![Image: Using a specific numbering sequence with the ROW function](https://www.ionos.com/digitalguide/fileadmin/_processed_/c/3/csm_using-a-specific-numbering-sequence-with-the-row-function_59e1421954.webp "Using a specific numbering sequence with the ROW function")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/using-a-specific-numbering-sequence-with-the-row-function.png) Using a specific numbering sequence with the ROW function Drag the fill box down again. The ROW function will insert the numbering **automatically**.

[![Image: Automatic numbering with the ROW function](https://www.ionos.com/digitalguide/fileadmin/_processed_/4/1/csm_automatic-numbering-with-the-row-function_088c0c3c4c.webp "Automatic numbering with the ROW function")](https://www.ionos.com/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/automatic-numbering-with-the-row-function.png) Automatic numbering with the ROW function  Tip For more professional spreadsheets, a whole range of tricks is available to [format a table in Excel](https://www.ionos.com/digitalguide/online-marketing/online-sales/creating-an-excel-table/ "Creating an Excel table").


This is a markdown version of: [https://www.ionos.com/digitalguide/online-marketing/online-sales/excel-automatic-numbering/](https://www.ionos.com/digitalguide/online-marketing/online-sales/excel-automatic-numbering/) for AI/LLM consumption.