Microsoft Office Tutorials and References
In Depth Information
Using the Auto Fill Options Menu
5
Release the mouse button to
create a month name series
January through June in the
range B3:G3 and copy the format
in cell B3 to the range C3:G3.
Click the Auto Fill Options button
below the lower-right corner of
the fi ll area to display the Auto
Fill Options menu (Figure 3–8).
What if I do not want to copy the
format of cell B3 during the auto
fi ll operation?
In addition to creating a series of
values, dragging the fi ll handle
instructs Excel to copy the format
of cell B3 to the range C3:G3.
With some fi ll operations, you
may not want to copy the formats
of the source cell or range to the
destination cell or range. If this is
the case, click the Auto Fill
Options button after the range
fi lls (Figure 3–8) and then select
the option you desire on the Auto
Fill Options menu.
months of year
propagated using
fi ll handle
Auto Fill
Options button
format of cell B3
applied to range
C3:G3
Auto Fill
Options menu
Figure 3–8
6
Click the Auto Fill Options button to hide the Auto Fill Options menu.
Click cell H3, type Total , and then press the RIGHT ARROW key.
Why is the word Total automatically formatted with the Heading 3 cell style and 45° rotation?
Excel tries to save you time by automatically recognizing the adjacent cell format in cell G3
and applying it to cell H3. The Heading 3 cell style in cell G3 causes this action to occur.
Other Ways
1. Enter start month in
cell, apply formatting,
right-drag fi ll handle
in direction to fi ll,
click Fill Months on
shortcut menu
2. Enter start month in
cell, apply formatting,
select range, click Fill
button on Home tab
on Ribbon, click Series,
click AutoFill
Using the Auto Fill Options Menu
As shown in Figure 3–8, Fill Series is the default option that Excel uses to fi ll the
area, which means it fi lls the destination area with a series, using the same formatting as
the source area. If you choose another option on the Auto Fill Options menu, then Excel
immediately changes the contents of the destination range. Following the use of the fi ll
handle, the Auto Fill Options button remains active until you begin the next Excel operation.
Table 3–2 summarizes the options on the Auto Fill Options menu.
 
 
Search JabSto ::




Custom Search