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
