Fixing text wrap in merged cells
 

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!

Fixing text wrap in merged cells
 

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!