Automatically add/insert Serial Number MS Excel

1. Insert a new column to add serial number;
2. Write 1 in the first row of newly created column
3. Select column and row (based on your requirement) .
4. Then Click Home -> Fill -> Series.
5. You Will get a window like below

 

     6. Click Ok And get your serial number.