This post will guide you how to generate unique sequential numbers in Excel. How do I insert unique sequence numbers to your worksheet in Excel.
Insert Unique Sequential Numbers
Assuming that you want to insert unique sequential numbers, such as: 1,2,3….in Excel. You just need to do the following steps:
#1 select one cell, and type number 1
#2 type number 2 in another cell beside the first cell.
#3 select the above two cells, and drag the AutoFill Handle down the other cells in the same column.
The sequential numbers have been generated in that column.