Excel, unlike other Microsoft Office programmes, does not have a button that automatically numbers data. However, by sliding the fill handle to fill a column with a succession of numbers or by using the ROW function, you may quickly add sequential numbers to rows of data.
Tip: If you have Access installed on your computer and want a more advanced auto-numbering method for your data, you may import the Excel data into an Access database. When you create a new record in a table in an Access database, you can establish a column that creates a unique number automatically.
Fill in the blanks in a column with a series of numbers.
Fill the first cell in the range with whatever you wish.
Fill in the series' initial value.
To start a pattern, type a value in the next cell.
Choose the cells that have the initial values in them.
When you select more than one cell holding data in Excel 2013 and later, the Quick Analysis button appears by default. To finish this procedure, you can disregard the button.