Wrap text automatically
- In a worksheet, select the cells that you want to format.
- On the Home tab, in the Alignment group, click Wrap Text .Notes
- Data in the cell wraps to fit the column width. When you change the column width, data wrapping adjusts automatically.
- If all wrapped text is not visible, it may be because the row is set to a specific height or that the text is in a range of cells that has been merged.To make all wrapped text visibly, do the following to manually adjust the row height:
- Select the cell or range for which you want to adjust the row height.
- On the Home tab, in the Cells group, click Format.
- Under Cell Size , do one of the following:
- To automatically adjust the row height, click AutoFit Row Height.
- To specify a row height, click Row Height, and then type the row height that you want in the Row height box.
TIP: You can also drag the bottom border of the row to the height that shows all wrapped text.
Enter a line break
You can start a new line of text at any specific point in a cell.
- Double-click the cell in which you want to enter a line break.Keyboard shortcut You can also select the cell, and then press F2.
- In the cell, click the location where you want to break the line, and then press ALT+ENTER.