Microsoft Office Tutorials and References
In Depth Information
Rotating Text and Using the Fill Handle to Create a Series
2
Lift your nger or
release the mouse
button to create a
month name series
in the selected range
and copy the format
of the selected cell
to the selected
range.
Tap or click the ‘Auto
Fill Options’ button
below the
lowerright corner of the
fill area to display
the Auto Fill Options
menu (Figure 3 – 8).
format of cell B3 applied
to range C3:G3
months propagated
using fill handle
‘Auto Fill
Options’
button
Auto Fill
Options menu
What if I do not
want to copy the
format of cell B3
during the auto fill
operation?
In addition to creating a series of values, dragging the fill handle instructs Excel to copy the format of cell B3 to the
range C3:G3. With some fill 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, tap or click the ‘Auto Fill Options’ button after the range fills and then
select the option you desire on the Auto Fill Options menu (Figure 3 – 8).
Figure 3 – 8
3
Tap or click the ‘Auto Fill Options’ button to hide the Auto Fill Options menu.
Select cell H3, type Total , and then tap cell I3 or press the RIGHT ARROW key to enter a column heading.
Type Chart in cell I3 and then tap cell J3 or press the RIGHT ARROW key to enter a column heading.
Why is the word, Total, automatically formatted with a 45° rotation?
Excel tries to save you time by automatically recognizing the adjacent cell format in cell G3 and applying it to
cell H3. Such behavior also occurs when typing the column heading in cell I3.
Other Ways
1. Type text in cell, apply formatting, right-drag fill handle in direction
to fill, tap or click Fill Months on shortcut menu
2. Type text in cell, apply formatting, select range, tap or click Fill button
(HOME tab | Editing group), tap or click Series, tap or click AutoFill
(Series dialog box), tap or click OK button
Using the Auto Fill Options Menu
As shown in Figure 3 – 8, Fill Series is the default option that Excel uses to fill an
area, which means it fills 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 fill 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.
BTW
The Fill Handle
If you drag the fill handle
to the left or up, Excel will
decrement the series rather
than increment the series. To
copy a word, such as January
or Monday, which Excel
might interpret as the start of
a series, hold down the CTRL
key while you drag the fill
handle to a destination area.
If you drag the fill handle
back into the middle of a cell,
Excel erases the contents of
the cell.
 
Search JabSto ::




Custom Search