Microsoft Office Tutorials and References
In Depth Information
Rotating Text and Using the Fill Handle to Create a Series
Click the Auto Fill Options button to hide the Auto Fill Options menu.
Total , and then press the RIGHT ARROW key to enter a column
Select cell H10, type
Type Chart in cell I10 and then 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 G10
and applying it to cell H10. Such behavior also occurs when typing the column heading in
1. Enter start month in cell,
apply formatting, right-
drag i ll handle in direction
to i ll, click Fill Months on
2. Enter start month in cell,
apply formatting, select
range, click Fill button
(Home tab | Editing group),
click Series, click AutoFill
Using the Auto Fill Options Menu
As shown in Figure 3 – 8 on the previous page, Fill Series is the default option that
Excel uses to i ll an area, which means it i 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 i 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.
Rotating Text in a Cell
In Excel, you use the
Alignment sheet of the
Format Cells dialog box,
as shown in Figure 3–5 on
page 146, to position data
in a cell by centering, left-
aligning, or right-aligning;
indenting; aligning at the
top, bottom, or center;
and rotating. If you enter
90 in the Degrees box in
the Orientation area, the
text will appear vertically
and read from bottom to
top in the cell.
Table 3 – 2 Options Available on the Auto Fill Options Menu
Auto Fill Option
Fill destination area with contents using format of source area. Do not create a series.
Fill destination area with series using format of source area. This option is the default.
Fill Formatting Only
Fill destination area using format of source area. No content is copied unless i ll
Fill Without Formatting
Fill destination area with contents, without the formatting of source area.
Fill destination area with series of months using format of source area. Same as Fill
Series and shows as an option only if source area contains a month.
The Mighty Fill Handle
If you drag the i ll 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 i ll handle to
a destination area. If you
drag the i ll handle back
into the middle of a cell,
Excel erases the contents
of the cell.
You can use the i ll handle to create a series longer than the one shown in
Figure 3–8. If you drag the i ll handle past cell G10 in Step 4, Excel continues to
increment the months and logically will repeat July, August, and so on, if you extend the
range far enough to the right.
You can create several different types of series using the i ll handle. Table 3 – 3
illustrates several examples. Notice in examples 4 through 7, 9, and 11 that, if you use
the i ll handle to create a series of numbers or nonsequential months, you must enter
the i rst item in the series in one cell and the second item in the series in an adjacent cell.
Excel still creates the series, however, if the i rst two items are in a range and the cells
between the items are empty. Next, select both cells and drag the i ll handle through
the destination area.