Q. How can I make text in a cell display in multiple lines?

When entering text into the cell, press Alt-Enter to insert a line break.

When you do so, Excel will automatically apply text wrapping to the cell. To reformat existing cells so they sport wrapped text, select the cells and then choose Format, Cells. On the Alignment tab, select "Wrap text," and click OK.

0 comments