Question

which is the easiest method to fill data in cell automatically

Answer 1

Answer:

1.Select one or more cells you want to use as a basis of filling additional cells.For a series like 1,2,3,4,5,....,type 1 & 2 in the first two cells.For the series 2,4,6,8,...,type 2 & 4 in the first two cells.

2.Drag the fill handle.

3.If needed, click the Auto fill options and choose the option you wanted.