Auto Fill or Auto Generate Serial Number Column in Excel without Dragging or Using Any Formulas

In excel sheet automatically generating serial number column is one of the key issue especially when data list is large and you have not apply any formula to the serial number column.

I am going to show you a very simple trick, which you can use in the excel sheet to automatically generate or auto fill the serial number column without using any formula or dragging in excel sheet. This trick is applicable to any version of excel.