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

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

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