Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Generate the Sequence Numbers automatically in Excel 2016

Date:2019-8-9 Author:Olivia

For a worksheet with sequence numbers, inserting a row into it means re-numbering the sequence column. Not only inconvenient to operate, but it takes a lot of workload to modify them. So how can we achieve it? Here’s a simple guide.

First, enter all contents you want to generate the sequence numbers.

How to Generate the Sequence Numbers automatically in Excel 2016

Then, enter the formula “=Row()-1 ” in the cell “A2”, and press Enter in keyboard, then you get the result of row 2.

How to Generate the Sequence Numbers automatically in Excel 2016

Next, select “A2” and move the mouse to the bottom right corner of it, a small black cross appears. Left click the mouse and drag to the last row.

How to Generate the Sequence Numbers automatically in Excel 2016

How to Generate the Sequence Numbers automatically in Excel 2016

Now you get the method of how to generate the sequence numbers automatically in excel. If there are a large amount of numbers, simply double click the small black cross, and the result is the same.

Note: Inserting or deleting some rows, the rest of the contents will be automatically generated again, instead of adding or reserving empty blank line.

How to Generate the Sequence Numbers automatically in Excel 2016

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

1 thought on “How to Generate the Sequence Numbers automatically in Excel 2016”

  1. vurtilopmer says:

    Enjoyed studying this, very good stuff, thanks. “Love begets love, love knows no rules, this is the same for all.” by Virgil.

Leave a Reply

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