How to create an automatic sequence in excel sheet.
write sequence formula in cell in which you want serial number of data
under the sequence formula write COUNTA formula and then select the range or column for which you want serial number for your data list then press enter.
Now your auto number sequence is ready.