hi,

this is à known problem, there is no automatic solution.
i suggest you format these cells: Horizontal Alignment "Center Across
Selection"

isabelle

Le 2013-11-14 04:45, Robert Crandal a écrit :
Cells A1 and B1 are merged with "Wrap text" enabled.

If I type long strings into this merged cell, only the first few words
will be visible. That is the problem.

Also, someone already mentioned that I could press Alt-Enter after
I type the text, but this is not acceptable because the text disappears
as soon as I click on another cell. Also, I don't want my users
to press Alt-Enter after entering data into this spreadsheet.

I need a solution that will allow the ENTIRE text string to be
visible in the merged cell, no matter how long the text string.
Does that mean I need to write VBA code that expands the height
of this row? How about tooltips? Can I create a tooltip textbox
that displays all the data if someone hovers the mouse over this
merged cell??

I'd appreciate any ideas here. Thank you!