7 ways to insert Automatic Serial Numbers in Excel

[@robh.1212]

I want excel to assign a unique number to each row and i want that number to NOT change if I sort my table or if I delete a row. In other words if I have 15 rows and I enter a 16th row I want Excel to auto name it serial number 16 and that serial number will stay with that row no matter if other rows are added or deleted and no mater how I sort those rows. How can I do that?

[@bernadetagalea7118]

Thanks

[@bernardmushibwe1020]

Perfect ❤

[@datacense]

Thank you

[@mukulanand2]

nice

[@datacense]

Thank you 🙏