Automatic Numbering in Excel

MS EXCEL TUTORIAL URDU

In this lesson, you will learn how to do automatic numbering in Excel. To do this follow these steps:

Write the first two digits in the numbering you want, so that Excel understands how much you want. For example, if you type 1 and 2, Excel will understand that the increment is 1. Similarly, if you type 30 and 40, Excel will understand that Is 10 and so … then select the two cells and then go to the bottom corner of the right and when the pointer turns to the symbol + drag to the last cell.

Excel will auto-number each time by 1

As another example, if you want to increase the amount to 5, write the numbers 5 and 10 and then select the two cells and then go to the bottom corner of the right and when the shape of the pointer to the symbol + drag until the last cell.

Excel will auto-number each time by 5

Leave a comment

* - Required fields