Wrap text in a cell

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.

ShowWrap 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.

ShowEnter 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.

 
 
Applies to:
Excel 2003