Cloud Training (Online)

How to quickly insert sequence numbers in Excel?

This blog post will demonstrate how you can insert the unique sequence numbers in Microsoft Excel 2016.

How to quickly insert sequence numbers in Excel?

There are times when you might want to insert sequential number starting from 1 to identify each row uniquely.

1. Lets say that you want the column A to contain the sequence number. Enter 1 in the cell A1 and then enter 2 in the cell A2.

2. Select both the cells and drag the Fill handle across the range of cells where you want the sequence numbers to be filled. Note that the difference between the cell A2 and A1 is considered for generating the subsequent sequence number.


Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.