How to Add Autonumber in Excel

One of the functions contained in excel is a feature for make automatic numbering function excel, How to Add Autonumber in Excel. Its use these functions quite easily practiced and fairly easy to remember also the logic function. There are only using the mouse, by doing click and drag without writing formulas the automatic numbering function. But there is also using automatic numbering function formula, of course, the mouse function is also still used to drive to one of the cells that will be stuffing the logic functions.

How to Add Autonumber in Excel

One of the functions contained in excel is a feature to make automatic numbering function excel. Its use these functions quite easily practiced and fairly easy to remember also the logic function. There are only using the mouse, by doing click and drag without writing formulas the automatic numbering function. But there is also using automatic numbering function formula, of course, the mouse function is also still used to drive to one of the cells that will be stuffing the logic functions.

1. The first way is to use the functions of a computer mouse / laptop. Use function click and drag or click and drag (drag) the number of rows or columns will be filled in automatically. An example is in the picture below. Fill Cells B3 with number 1 (one), then the contents of cell B4 with number 2 (two). After the second position the cursor in the cell. Then drag down and result numbers will automatically appear in a sequence of 1, 2, 3, 4, 5, and so on. 
2. The second way is to write the automatic numbering function in cells contained in Ms. Excel. Fill in B cells with = IF (ISBLANK (C3); ""; 1) then the contents of the cell B4 = IF (ISBLANK (C4); ""; B3 + 1) after the drag formula in cell B4 down, as much as you want. The result each time you fill out the description in column C3, C4, C5 and all cell column C, column B cells will automatically be filled itself with sequence numbers from smallest to largest. Further explanation please see the video tutorial Creating an automatic numbering function in Microsoft Excel below:

Very easy and simple is not it? Yes, Making Automatic Numbering function in Excel is not as difficult as what is imagined by those who have not been able to use the Excel function. and now you are able to perform troubleshooting How to Add Autonumber in Excel.