How to implement automatic fill for Excel

In the use of Excel, we often use the automatic filling of the situation, but an automatic fill, will appear in the top of the cell form, to engage in the cause of people headaches. In fact, when you want to automatically fill a series of numbers that have a step size in a column cell, the automatic padding is as follows:

　Method One:

1, in the input is a numerical case, fill in the first serial number

2, in the cell properties, select the value

3, the number of decimal points after the selection of 0

4, select the second sequence number to enter the cell, input function (I selected is the first column) =a1+1, enter

Then pull with the drag handle to get the data you want.

　　Method Two:

1, in the first, the second cell input two adjacent values (cell properties should be set to a numeric format, after the decimal point set to 0 bits)

2, select the two adjacent values, drag the fill handle, you can also get the desired value