Knowledgebase: Microsoft Excel
How to wrap text in a cell?
Posted by - NA - on 17 April 2006 01:50 AM
Solution:

If you want text to appear on multiple lines in a cell, you can format the cell so that text wraps automatically, or you can enter a manual line break.

Wrap text automatically

1. Select the cells you want to format.
2. On the Format menu, click Cells, and then click the Alignment tab.
3. Under Text control, select the Wrap text check box, and then click OK.

Note: Data in the cell will wrap to fit the column width. When you change the column width, data wrapping adjusts automatically.

Enter a line break

To start a new line of text at a specific point in a cell, click where you want to break the line, and then press ALT+ENTER.

Note: If all wrapped text is not visible, it may be because the row is set to a specific height. To allow the row to adjust automatically and show all wrapped text, point to Row on the Format menu, and then click AutoFit.
(149 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako Fusion