HOW TO INSERT SERIAL NUMBER IN MS EXCEL
In MS Excel, inserting a Serial Number is a very basic but necessary task. Often, we manually write 1,2,3 and drag it down, but sometimes we need a formula that automatically generates numbering - whether we insert a row in between, delete one, or if the data is blank.
In today 's post, we will learn how to insert Numbers in Excel using a formula and which method is best suited to your needs.
METHOD 1: -
Step 1: - Open your worksheet in MS EXCEL.
Step 2: -First Write serial numbers 1 and 2 in the first two rows and then select both of them and drag them downward using the mouse.
Step 3: -Then you will see that serial number will be inserted automatically
The serial number are inserted by dragging, but when you delete any row or column in your data, the serial numbers get mismatched. There is a best method for this, which is given below.
Step 1: -Open your worksheet in MS EXCEL.
Step 2: - Now we will use a formula in MS EXCEL to properly adjust our serial numbers.First , we will write formula in the topmost row.
FORMULA IS: - ROW ()-1
Step 2: - Now drag to down
Step 3: - Then you see serial number automatically insert.
Now whenever you delete any number then serial number automatic inserted.
WHAT WE LEARNED?
In this post, we learned that in MS Excel, we can use simple formulas to add serial number, like ROW ()-1. With the help of these formulas, numbering is generated automatically, you don't need to type it manually, and if data is updated or rows are deleted, the serial numbers adjust automatically. In this way, you can make your Excel sheet professional and error free. If you like our post so, please like and share it.
RELATED VIDEO LINK:
0 Comments