Log in

View Full Version : Multi line cells in excel


Capuchin
Jan 2, 2007, 02:19 AM
Hey guys, any idea how to have multiple lines in a single cell in excel?

I'm trying to make my table look a little neater, but it makes some of my comments overlap into following cells - is there any way to make the rows higher and to have 2 lines of text in a cell?

Thanks in advance - Cap

Curlyben
Jan 2, 2007, 02:24 AM
Erm how about a simple WRAP TEXT ;)

Capuchin
Jan 2, 2007, 02:25 AM
Where's that button?

Edit - Found it. Rep++

Curlyben
Jan 2, 2007, 02:27 AM
RIGHT click the cell > Format Cells > Aligment Tab > Text Control near the bottom

ScottGem
Jan 2, 2007, 08:22 AM
You can FORCE a linebreak using Alt+enter