Wrap text in a cell - Excel - Microsoft Office Online

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

Wrap text in a cell

Applies to: Microsoft Office Excel 2003

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.

Show Wrap text automatically

Select the cells you want to format.
On the Format menu, click Cells, and then click the Alignment tab.
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.

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

Related Office Online discussions

Read related questions and answers from other Microsoft Office customers.