Microsoft Office Tutorials and References
In Depth Information
Changing Data Orientation
Now, in order to make that happen, you need to learn how to heighten a row. We’ve
already talked about widening a column; row heightening works in a similar way:
1.
Move your mouse above
the lower boundary of the
row you want to heighten
(see Figure 5–26).
Figure 5–26. Placing the cursor here with let you
heighten row 15.
2.
Click and drag the boundary down until the row achieves the desired
height. Release the mouse.
3.
You can heighten multiple rows at the same time by dragging atop
adjoining row headers (see Figure 5–27).
Figure 5–27. Heightening several rows simultaneously
4.
Then drag any one of the selected row boundaries to the desired height
and release the mouse. All the rows will acquire the same new height.
5.
Click anywhere to turn off the blue selection color.
6.
If you’ve dragged too far you can also execute a row autofit by
doubleclicking a row’s lower boundary.
Once you’ve completed that task, all you need to do is select your data and click one of
the Vertical Align buttons to bring about the effect you want. Of course, Bottom Align is
Excel’s default—data will automatically position itself on the bottom of a row unless you
decide to make a change.
Changing Data Orientation
The next alignment button, called Orientation, will let you do something even more
unusual: incline data at an angle. Click its drop-down arrow, and you’ll see the options
shown in Figure 5–28.
 
Search JabSto ::




Custom Search