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.

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar