Microsoft Office Tutorials and References
In Depth Information
Rotating Text and Using the Fill Handle to Create a Series
To Rotate Text and Use the Fill Handle to Create a Series of Month Names
The design of the worksheet calls specii cally for only six months of data. Because there always will be only six
months of data in the worksheet, the months should be placed across the top of the worksheet as column headings
rather than as row headings. The data for the worksheet includes more data items regarding each month than there
are months, and, possibly, more expense categories could be added in the future. A proper layout, therefore, includes
placing each month as column headings.
When you i rst enter text, its angle is zero degrees (0°), and it reads from left to right in a cell. Excel allows
you to rotate text in a cell counterclockwise by entering a number between 1° and 90°.
The following steps enter the month name, July, in cell B10; format cell B10 (including rotating the text); and
then use the i ll handle to enter the remaining month names in the range C10:G10.
Home tab active
If necessary, select the
Home tab and then
select cell B10 because
this cell will include
the i rst month name
in the series of month
Format Cells
dialog box
Orientation area
July as the
cell entry and then
click the Enter box.
Click the Format Cells:
Note: To help you
locate screen elements
that are referenced in
the step instructions,
such as buttons and
commands, this topic
uses red boxes to
point to these screen
Alignment Dialog Box
Launcher (Home tab |
Alignment group) to
display the Format
Cells dialog box
(Figure 3 – 4).
cell B10 selected
Figure 3 – 4
Search JabSto ::

Custom Search