Insert Unique Sequential Numbers

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.


So empty here ... leave a comment!

Leave a Reply