Microsoft Office Tutorials and References
In Depth Information
Altering the Alignment
Selecting Wrap Text breaks up the long text entries (that either spill over or
cut off) in the selection into separate lines. To accommodate more than one
line in a cell, the program automatically expands the row height so that the
entire wrapped-text entry is visible.
When you select Wrap Text, Excel continues to use the horizontal and vertical
alignment you specify for the cell. You can use any of the Horizontal alignment
options found on the Alignment tab of the Format Cells dialog box (Ctrl+1),
including Left (Indent), Center, Right (Indent), Justify, or Center Across
Selection. However, you can’t use the Fill option or Distributed (Indent) option.
Select the Fill option on the Horizontal drop-down list box only when you want
Excel to repeat the entry across the entire width of the cell.
If you want to wrap a text entry in its cell and have Excel justify the text with
both the left and right borders of the cell, select the Justify option from the
Horizontal drop-down list box in the Alignment tab in the Format Cells
You can break a long text entry into separate lines by positioning the insertion
point in the cell entry (or on the Formula bar) at the place where you want the
new line to start and pressing Alt+Enter. Excel expands the row containing the
cell (and the Formula bar above) when it starts a new line. When you press
Enter to complete the entry or edit, Excel automatically wraps the text in the
cell, according to the cell’s column width and the position of the line break.
Reorienting cell entries
Instead of wrapping text entries in cells, you may find it more beneficial to
change the orientation of the text by rotating the text up (in a
counterclockwise direction) or down (in a clockwise direction). Peruse Figure 3-16 for a
situation where changing the orientation of the wrapped column headings
works much better than just wrapping them in their normal orientation in
This example shows the same column headings for the sample order form I
introduced in Figure 3-15 after rotating them 90 degrees counterclockwise.
To make this switch with the cell range B2:H2 selected, click the Orientation
button in the Alignment group on the Home tab and then click the Rotate
Text Up option on the drop-down menu.
Figure 3-17 shows the same headings rotated up at a 45-degree angle. To
create what you see in this figure, you click the Angle Counterclockwise
option on the Orientation button’s drop-down menu after making the same
cell selection, B2:H2.