Forum Discussion
excel
I cant figure out a way to easily make my textboxes in excel have multiple lines of text. please help.
I know about the Alt Enter method, but I would have to do that everytime I want to start a new line.
1 Reply
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. (On Excel for desktop, you can also select the cell, and then press Alt + H + W.)
Notes:
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.
