Autofilling cells is quick and simple. Select the cell you would like to start from and click the icon in the bottom right of the cell. 

Then drag down and Excel will autofill depending on the contents of your original cell.

Use Flash Fill to split or join text in cells