Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break.
Wrap text automatically
-
In a worksheet, select the cells that you want to format.
-
On the Home tab, in the Alignment group, select Wrap Text. (On Excel for desktop, you can also select the cell, and then press Alt + H + W.)
:
-
Data in the cell wraps to fit the column width, so if 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.
-
Adjust the row height to make all wrapped text visible
-
Select the cell or range for which you want to adjust the row height.
-
On the Home tab, in the Cells group, select Format.
-
Under Cell Size, do one of the following:
-
To automatically adjust the row height, select AutoFit Row Height.
-
To specify a row height, select Row Height, and then type the row height that you want in the Row height box.
: You can also drag the bottom border of the row to the height that shows all wrapped text.
-
Enter a line break
To 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.
: You can also select the cell, and then press F2.
-
In the cell, select the location where you want to break the line, and press Alt + Enter.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.