Question

How will you create a list of numbers 1,2,3…..50 in Excel 2013?​

Answer 1

Answer:

We can create a list of numbers in Excel 2013 using Autofill.

The steps are:

• i. We type the first two numbers i.e. 1 and 2 in two adjacent cells.
• ii. We then select the two cells and clicking on the fill handle in the lower-right corner of the selected cells, we drag it to the area we want to fill, i.e. until we reach 50.
• iii. Then we release the mouse button. The list with the range of number will get filled automatically.

Answer 2

Answer:

We can create a list of numbers in Excel 2013 using Autofill.

The steps are:

i. We type the first two numbers i.e. 1 and 2 in two adjacent

cells.

ii. We then select the two cells and clicking on the fill handle

in the lower-right corner of the selected cells, we drag it to

the area we want to fill, i.e. until we reach 50.

iii. Then we release the mouse button. The list with the range

of number will get filled automatically.