Microsoft Office Tutorials and References
In Depth Information
Applying Auto Fill to different series
1, 2, 3
4, 5, 6, ...
2, 4, 6
8, 10, 12, ...
Dates and Times
Feb, Mar, Apr, ...
February, March, April, ...
Jul, Oct, Jan, ...
15-Mar, 15-Apr, 15-May, ...
12/31/2005, 1/1/2006, 1/2/2006, ...
2/28/2006, 3/31/2006, 4/30/2006, ...
Tue, Wed, Thu, ...
Tuesday, Wednesday, Thursday, ...
12:00 PM, 1:00 PM, 2:00 PM, ...
2nd period, 3rd period, 4th period, ...
Region 2, Region 3, Region 4, ...
Quarter 4, Quarter 1, Quarter 2, ...
Qtr4, Qtr1, Qtr2, ...
Amanda would like to replace dates in the Budget worksheet with the abbreviations of
each month. Rather than directly typing this text, you will insert the abbreviations using
the fill handle.
To fill in the abbreviations for the months of the year:
1. Press the Ctrl + Home keys to make the columns on the left and the top rows visible.
2. Click cell B4 , type Jan , and then click the Enter button on the Formula bar. Because
“Jan” is a commonly used abbreviation for January, Excel will recognize it as a month with-
out your having to type in “Feb” for the next month in the series.
3. Position the pointer over the fill handle in the lower-right corner of cell B4 until the pointer
4. Drag the fill handle over the range B4:M4 , and then release the mouse button. Excel fills in
the abbreviation for each month in the range of cells, as shown in Figure 2-21. As you drag
the fill handle, ScreenTips for the month abbreviations appear.
Filling in the month abbreviations
series filled in based on the abbreviation
for the month of January found in cell B4