Auto Fill dates

1. Select a cell and type the first word of a series (e.g. type "January" for a 12-month series).

2. Select the fill handle   at the lower-right corner of the cell, hold down, and drag to fill the rest of the series. Fill handles can be dragged up, down, or across a spreadsheet.
   

   Note: If you only enter a three-letter abbreviation (e.g. "Jan") in the cell, Auto Fill will automatically fill in the rest of the series.

Want more?

Create a list of sequential dates

Fill data automatically in worksheet cells

Fill a formula down into adjacent cells