Microsoft Office Tutorials and References
In Depth Information
Rotating Text and Using the Fill Handle to Create a Series
3
Tap or click the OK
button to rotate the
text in the active cell
and automatically
increase the height
of the current row to
best t the rotated
text (Figure 3 – 6).
text in cell B3
rotated 45°
height of row 3
automatically
changed to best t to
display rotated text
fill handle
Figure 3 – 6
Other Ways
1. Type text in cell, tap or click Orientation button
(HOME tab | Alignment Group), tap or click Angle
Counterclockwise
2. Type text in cell, press and hold and then tap ‘Show Context Menu’, or
rightclick cell, tap or click Format Cells on shortcut menu, tap or click Alignment tab
(Format Cells dialog box), tap or click 45° point, tap or click OK button
To Use the Fill Handle to
Create a Series of Month Names
1 ENTER HEADINGS & DATA | 2 ENTER FORMULAS & FUNCTIONS | 3 CREATE SPARKLINE CHARTS
4 FORMAT WORKSHEET | 5 CREATE COLUMN CHART | 6 CHANGE VIEWS | 7 ASK WHAT - IF QUESTIONS
Why? Once the rst month in the series has been entered and formatted, you can complete the data series using the
fill handle rather than typing and formatting all the entries.
The following steps use the fill handle and the entry in cell B3 to create a series of month names in cells
C3:G3.
1
If you are using a
touch screen, tap
cell B3, tap AutoFill
on the mini toolbar
and then drag the
AutoFill icon below
cell B3 to the right
to select the range
to fill, C3:G3 in this
case. Do not lift your
nger.
If you are using a
mouse, drag the
fill handle on the
lower-right corner of
cell B3 to the right
to select the range
to fill, C3:G3 in this
case. Do not release
the mouse button
(Figure 3 – 7).
fill handle dragged
to cell G3
ScreenTip indicates
proposed value of
rightmost cell
Figure 3 – 7
 
Search JabSto ::




Custom Search