Double lines of text in one cell

[Gary]

How can one generate double line of text that is
shrunk to fit into one cell? Currently with word wrap text
goes out of view.

Any help would be much appreciated.

 

[Charlie]

While entering text in a cell pressing Alt and Enter will
force the text into two lines.

Charlie O'Neill

 

[Gord Dibben]

Gary

With wrap text set on, Format>Row>Autofit.

Note: you can break your lines of text at a chosen point by hitting ALT +
ENTER to create a new line in the cell.

This is how<ALT + ENTER>
it looks.

Gord Dibben Excel MVP