Inserting the Next Consecutive Integer in Excel. Creating a list of consecutive numbers is one of the easiest ways to create unique IDs for product lists, transaction IDs or event numbers.