Microsoft Office Tutorials and References
In Depth Information
l Excel changes the series
to a copy of the original
Type a pattern of
Repeat Steps 2 to 4.
l Excel fills the cell with the pattern.
Did You Know?
When you release the mouse button after creating a series, the AutoFill Options
button ( ) appears. Click the button to view a menu of options. If you want to
fill with the days of the week, you can click Fill Days or Fill Weekdays to fill with
Monday through Friday ( changes to ). You can also click the Fill Formatting
Only option ( changes to ) to change the formatting of the cell without
changing the contents. Click the Fill Without Formatting option ( changes to )
to change the contents of the filled cells without changing the formatting. You can
extend a series in any direction: up, down, left, or right.
Chapter 1: Boost Your Efficiency