Numbers to be continued from Column line to row line

Automatically number rows
Excel for Microsoft 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007
Unlike other Microsoft Office programs, Excel does not provide a button to number data automatically. But, you can easily add sequential numbers to rows of data by dragging the fill handle to fill a column with a series of numbers or by using the ROW function.

Tip: If you are looking for a more advanced auto-numbering system for your data, and Access is installed on your computer, you can import the Excel data to an Access database. In an Access database, you can create a field that automatically generates a unique number when you enter a new record in a table.

What do you want to do?
Fill a column with a series of numbers

Use the ROW function to number rows

Display or hide the fill handle

Fill a column with a series of numbers
Select the first cell in the range that you want to fill.

Type the starting value for the series.

Type a value in the next cell to establish a pattern.

Tip: For example, if you want the series 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. If you want the series 2, 4, 6, 8..., type 2 and 4.

Select the cells that contain the starting values.

Note: In Excel 2013 and later, the Quick Analysis button is displayed by default when you select more than one cell containing data. You can ignore the button to complete this procedure.

Drag the fill handle Fill handle across the range that you want to fill.

Note: As you drag the fill handle across each cell, Excel displays a preview of the value. If you want a different pattern, drag the fill handle by holding down the right-click button, and then choose a pattern.

To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.