Formatting Cells

S

Sergio Vega

Hello,

I am wondering if anyone know how to format a EXCEL cell
so all the text typed in it will show. The cell in
question has the merged cell box checked, and I can't find
a way to deselect it. If someone knows how to deselect
it, please advise.

My e-mail is [email protected]

Thank you,

--Sergio
 
J

jeff

Have you tried menu Format>Cells>check "Wrap text"
and then adjust the row height?

jeff
 
G

Gord Dibben

Sergio

You can set the merged cells to wrap-text.

Note: wrap-text is available with merged cells, but the row "autofit" doesn't
function with merged cells.

To clear the merging from cells.......Format>Cells>Alignment. Uncheck the
mark at "merge cells".

Gord Dibben Excel MVP
 
Top