Microsoft Office Tutorials and References
In Depth Information
Wrapping Text in a Cell
Wrapping Text in a Cell
If you need to enter a lot of text into a cell, you have two choices:
h Allow the text to spill over into the adjacent cell on the right.
h Allow the text to wrap so that it’s displayed on multiple lines within the cell.
If the cell to the right isn’t empty, the text appears to be cut off if you don’t wrap it. Figure 64-1
illustrates how different types of wrapped and unwrapped text can look.
Figure 64-1: Examples of lengthy text in cells.
Cell B2 contains the default formatting. Because the cells to the right are empty, the entire chunk
of text is visible.
Cell B4 contains the same text as B2, but the text appears to be cut off because cell C4 isn’t
empty.
Cell B6 uses the Wrap Text option, which is available in the Home
Alignment group.
If you change the column width of a cell that uses Wrap Text, you find that the row height
doesn’t change to compensate. For example, if you reduce the column width, some of the text
might not be displayed. If you increase the column width, you see extra white space in the cell.
To fix the row height after changing the column width, choose Home
AutoFit
Row Height. Also, remember that you can change the horizontal and vertical alignment of the
text. For example, you can center it horizontally and vertically.
Cells
Format
To force a line break in a cell, press Alt+Enter. If the cell isn’t already formatted with Wrap Text,
pressing Alt+Enter applies Wrap Text formatting automatically.
You can also merge cells together to hold lengthy text. See Tip 56 for more
information.
Another way to handle lengthy text is to put it in a text box (see Figure 64-2). Add a text box by
choosing Insert
Text Box and then just start typing. A text box is just a shape with text, so
you can format it any way you like. And, of course, you can position it without respect to cell
Text
 
Search JabSto ::




Custom Search