Microsoft Office Tutorials and References
In Depth Information
Wrap Text Within a Cell
5
chapter
Formatting Excel Ranges
3 Click Wrap Text (
).
Excel turns on text wrapping
for the selected cell.
A If the cell has more text
than can fit horizontally,
Excel wraps the text onto
multiple lines and increases
the row height to
compensate.
My text is only slightly bigger than the cell. Is there a way to view all of the text without
turning on text wrapping?
Yes. There are several things you can try. For example, you can widen the column until you see
all your text; see “Change the Column Width,” earlier in this chapter.
Alternatively, you can try reducing the cell font size. One way to do this is to choose a smaller
value in the Font Size list of the Home tab’s Font group. However, an easier way is to click the
Alignment group’s dialog box launcher ( ) to open the Format Cells dialog box with the
Alignment tab displayed. Click the Shrink to fit check box (
changes to
) and then click OK.
Search JabSto ::




Custom Search