HomeMicrosoft OfficeExcelHow to quickly insert sequence numbers in Excel?

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.

06E7EB48-9CA3-46A1-B58A-71088170BB07

    1 Comment

  1. User Avatar
    April 14, 2023
    Reply

    I doubted this topic but now I was done with it thanks, guys.

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021