I think there is a method for pre-populating a selected column with sequential 'serial' numbers. Forget what that is called, at the moment.

Select the column area that needs the numbers, activate the command and you should have your number series. This assumes that you know or can predict the total number of 'serial numbers' you need.