1. Open the Excel table that you want to fill with data, select the data you want to fill, hold down the CTRL key, move the mouse over the lower-right corner of the cell until the AutoFill option appears, and then drag the cell down.
2. This time we will find that the data has been filled with the fill sequence completed.
3. Of course, if we just want to copy the same sequence, then just click on the "AutoFill options", change it to "copy cell" can be, so that we automatically fill the data is the same, is not very simple?