Microsoft Office Tutorials and References
In Depth Information
Session 2.1
Applying Auto Fill to different series
Figure 2-20
Type
Initial Selection
Extended Series
Values
1, 2, 3
4, 5, 6, ...
2, 4, 6
8, 10, 12, ...
Dates and Times
Jan
Feb, Mar, Apr, ...
January
February, March, April, ...
Jan, Apr
Jul, Oct, Jan, ...
15-Jan, 15-Feb
15-Mar, 15-Apr, 15-May, ...
12/30/2005
12/31/2005, 1/1/2006, 1/2/2006, ...
12/31/2005, 1/31/2006
2/28/2006, 3/31/2006, 4/30/2006, ...
Mon
Tue, Wed, Thu, ...
Monday
Tuesday, Wednesday, Thursday, ...
11:00 AM
12:00 PM, 1:00 PM, 2:00 PM, ...
Patterned Text
1st period
2nd period, 3rd period, 4th period, ...
Region 1
Region 2, Region 3, Region 4, ...
Quarter 3
Quarter 4, Quarter 1, Quarter 2, ...
Qtr3
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
changes to
.
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
Figure 2-21
series filled in based on the abbreviation
for the month of January found in cell B4
Search JabSto ::




Custom Search