How to Wrap Text in a single cell

When text exceeds a column width, it is possible to manually or automatically wrap the text.
To manually wrap text, use Alt-Enter to enter the break point.

Wrap Text is a cell formatting option that forces text to break into lines within a cell.

 Select the cells that you wish to wrap text in. Right-click and then select "Format Cells" from the popup menu.

 When the Format Cells window appears, select the Alignment tab and select the "Wrap text" checkbox.

When you press "ok" the selected text should be wrapped.

( click on the image to enlarge it )

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.