• Dp

How To Quickly Generate Serial Numbers In Excel

Updated: Apr 30, 2019

In this video tutorial, let us learn how to easily generate serial numbers in excel data range.

This is very quick and easy to perform.


This is the auto generated serial number system in excel.


ROWS and ROW function have been used for this purpose, which gets automatically updated.


First Let me show the drawbacks of using general ways of performing this action.


1st Wrong Method:

Generally we would be simply using the fill down option like shown in the demo below.

the drawback of using this way, is that when we delete any particular row at later stage, it won't get updated automatically and shows wrong values. (like shown below)