Microsoft Office Tutorials and References
In Depth Information
Rotating Text and Using the Fill Handle to Create a Series EX 169
To Rotate Text and Use the Fill Handle to Create a Series of Month Names
Chapters 1 and 2 used the ﬁ ll handle to copy a cell or a range of cells to adjacent cells. The ﬁ ll handle also can
be used to create a series of numbers, dates, or month names automatically. The following steps enter the month
name, January, in cell B3; format cell B3 (including rotating the text); and then use the ﬁ ll handle to enter the
remaining month names in the range C3:G3.
• Select cell B3.
Home tab active
• Type January as the cell entry
and then click the Enter box.
• Click the Format Cells: Alignment
Dialog Box Launcher on the
Ribbon to display the Format
Cells dialog box (Figure 3-4).
cell B3 selected
• Click the 45° point in
the Orientation area to
move the Text hand in the
Orientation area to the 45°
point and to display 45 in the
Degrees box (Figure 3–5).