How to automatically add/insert serial numbers in MS excel?

Follow these steps if you want to add serial numbers to the rows in excel:

1) Insert a new column for adding serial numbers.

2) Write 1 in the first row of that newly created column.

3) Select that column and click on “Fill” under “Home”. This is for MS excel 2007. You can check for “Fill” accordingly if you are using a different version of excel.

4) Under “Fill” select “Series…”

5) Check the option “Columns” under “Series in”. Let the type be “Linear”. Select “Step value” as 1 and “Stop value” as per your requirements, say 1000. This stop value is number where counting will end.

6) Click on “Ok”. That’s it your new column will now be filled with serial numbers.


Leave a Reply

Your email address will not be published. Required fields are marked *

+ six = 7