TIP - 46 : Generate serial numbers in excel - row formula

Generate serial numbers in excel - row formula

This trick will help a lot for the people who enter serial numbers manually and a need for later to delete a record or records, then again needs to fix the serial numbers.

Now we can automate the same with a formula, which updates automatically whenever the records deleted.

Step 1: Enter formula into the cell from where you want to create numbering.

Formulas –

1)   = rows ($A$2:z A2) or

2)   = row(A2)-row($A$1)

Step 2: Drag or copy the above formula to the required range of cells

Now when we delete the any of the records, serial numbers automatically updated. Thank you 😊