R
Robert Crandal
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!
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!