Double lines of text in one cell

  • Thread starter Thread starter Gary
  • Start date Start date
G

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.
 
While entering text in a cell pressing Alt and Enter will
force the text into two lines.

Charlie O'Neill
 
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
 
Back
Top