Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text wrap merged cells | Excel Programming | |||
Text wrap in merged cells | Excel Discussion (Misc queries) | |||
Wrap text in merged cells VBA | Excel Discussion (Misc queries) | |||
Merged cells/wrap text | Excel Discussion (Misc queries) | |||
text wrap in merged cells | Excel Discussion (Misc queries) |