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.

Sidebar