Adding numbers automatically to a column in Excel can be done in two ways, using the ROW function or the Fill feature. The first method ensures that the cells display the correct row numbers even when rows are added or deleted.
Guide to Auto Numbering in Excel. Here, we number list automatically using AutoFill, ROW (), OFFSET (), examples & downloadable Excel templates.