Microsoft Office Tutorials and References
In Depth Information
Using Auto Fill with Text
Using Auto Fill with Text
But there’s more. Enter the word Tuesday in any cell. Return to the cell, grab onto the fill
handle, and start dragging to the right (as opposed to down the column. You can always
drag the fill handle vertically or horizontally). You’ll see:
Figure 2–30. Those were the days.
You see what’s happened, and it isn’t magic. Excel supplies the user with four built-in
auto fill sequences—
Days of the week
Three-lettered abbreviations of days of the week (e.g. Tue, Wed)
Months of the year
Three-lettered abbreviations of months of the year (e.g., Jul, Aug).
And you can start any of these sequences at any point—that is, you needn’t start with
January, for example; and when you run out of months or days the sequence starts over
again. Start with July, and when you reach the 13 th cell in the sequence you get July
NOTE: For appearance’s sake you may need to tinker with the column widths, because each day
consists of different word lengths—look at Wednesday in the above screen shot, for example.
Using the Auto Fill Option Button
When you drag the fill button and complete a filled list, you’ll notice a button neighboring
the fill handle, entitled Auto Fill options. If you had dragged a list featuring values spaced
two apart by starting with the numbers 1 and 3, you see:
Search JabSto ::

Custom Search