Excel has lots of useful Fill features. Here are just a few of them.
Here's a look at the Fill options available from the Edit menu.
Using Down, Right, Up and Left, you can quickly copy data, format or formulas into neighboring cells using the direction you choose. (Take note of the Ctrl + D and Ctrl + R shortcuts. Another useful shortcut is Ctrl + Enter which can be used to enter the same data or formula into multiple cells simultaneously)
You can also copy across Worksheets. Right click the Sheet tab to access Select All Sheets, then use Across Worksheets from the Edit, Fill menu.
There are some very good options available using the Series dialog box (Edit, Fill). Here are some examples.
Here I have used Linear which can be used to add the number entered in Step (in this case 10). I've also used Stop to for a maximum value of 50 (if I didn't use Stop, the series would continue to end of the range selected with the mouse)
In this case I have used Growth to multiply by 10. Again, the Step value is 10 so all cells that follow are in multiples of 10.
Here I have added months by using Date, Month with a Step Value of 3.
Finally , we have the Autofill option. To be honest, I think it's a lot easier to use the Auto Fill handle and it offers more options also, depending on what you actually want to do.
In the above picture I used a Step value of 3 to add 3 months at a time. This is also possible with Autofill, but you have to "specify" a step value by entering the first few cells to get the same step value throughout the range.
At the same time, if your are dealing with a step value of 1, then the Auto Fill handle may be the way to go.
You can also add make your own Custom lists by using Tools, Options, Custom Lists, NEW LIST. If you want to use the same data in the same order on a repeated basis, this is a very handy feature. Note that the list can be used continuously once entered, unless you choose to delete it later on.
Once your Custom List is set, you can just enter the first cell, then drag down to fill following cells with the entire list.