Auto Fill Options list contents while filling month names in Excel 2007

Enter January in cell A1. Change the color of the text to Red and the font to Cambria. Click cell A1 (cell A1 will have a thick border with a tiny black square at the lower right corner. This tiny black square is called the Fill handle).
Place the mouse cursor over the fill handle and drag it down till cell A4. You will see February, March, and April entered in cells A2, A3, and A4. You will also see the Auto Fill Options button at the lower right of cell A4. When you click the Auto Fill Options button, a list appears.

Eight options are available in the list. Depending on the data you are working, the options number change. When working with month names, five options are displayed. The list options are:

• Copy Cells
• Fill Series
• Fill Formatting Only
• Fill Without Formatting
• Fill Months

Copy Cells – When you click this option, cells A2, A3, and A4 will have the data January.
Fill Series – This option is selected by default and will enter February, March, and April in cells A2, A3, and A4.
Fill Formatting Only – When you click this option, cells A2, A3, and A4 are left blank. When you enter data in these cells, the cells will have red colored text with Cambria font because cell A1 has red colored text with Cambria font.
Fill Without Formatting – When you click this option, cells A2, A3, and A4 will have Calibri, which is the default font with text color as black. If a different font is set as the default then that font will be displayed in the cells.
Fill Months – This option performs the same operation as Fill Series.