» Filling a Range with a Series of Dates

To fill a range of cells with a series of dates:

1. Select cell A1, and press Ctrl+;.
2. Select cells A1 through A10.
3. From the Edit menu, select Fill, and then select Series.
4. In the Series dialog box, check the Date and Month option buttons, and then click OK.

Note: To fill a series of quarters, change the Step value to 3.

To fill a range of cells with a series of dates using a shortcut:

1. Select cell A1, and press Ctrl+;.
2. Select the Fill handle in the bottom-right corner of the cell. The cursor changes to a plus sign.
3. Right-click, drag vertically, and then release the mouse.
4. From the shortcut menu, select the series as desired.
A new feature from Excel 2002 enables the use of a Smart Tag to automatically change a series of dates.

To use a Smart Tag:

1. Select cell A1, and press Ctrl+;.
2. Click the Fill handle at the bottom-right corner of cell A1, and drag it to several cells in the column. Do not cancel the selection of the range of dates (Excel automatically creates a series according to days).
3. Click the arrow in the Smart Tag.
4. Select Fill Months.
Screenshot // Filling a Range with a Series of Dates