Powerful Excel Formula To Add Serial Number in Microsoft Excel Every excel project you ever think of has serial number. But most of the people add serial number in excel manually. Thankfully, there’s a powerful function that can generate hundreds of sequential serial numbers instantly. It’s called SEQUENCE Function. Its available in excel 2021 and above. Here is the formula that will give you a serial number from 1 to 1000. =SEQUENCE(1000,1) The formula above tells Excel to generate 1000 numbers

How to Create Automatic Serial Number In Microsoft Excel I've written an excel formula that will create dynamic serial number. It means every time you enter data the serial number will automatically update. The Formula is: =SEQUENCE(COUNTA(B2:B35)) | Excel 10 Tutorial