Formatting Cells

[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 (e-mail address removed)

Thank you,

--Sergio

 

[jeff]

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

jeff

 

[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