Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is there an option to automatically adjust row height to
display all the text in a cell with wrap text selected? |
#2
![]() |
|||
|
|||
![]()
You asked "with wrap text selected" - Do you mean "without wrap text selected"?
Once you type the content into a cell and apply wrapping, the row ht. should automatically adjust accordingly unless the ht. was previously increased using a manual technique (such as dragging the row divider or FormatRowHeight). If the height has beenmanually changed, just Double-Click the separator between the row number of that row & the one beneath it. You can also turn text wrap OFF, reset the row height to it's default, then reset text wrap. That should cause the height to automatically adjust as well. HTH |:) HTH |:) "anonymous" wrote: Is there an option to automatically adjust row height to display all the text in a cell with wrap text selected? |
#3
![]() |
|||
|
|||
![]()
It turns out the problem was due to merged cells. For some
reason wrap text does not work when cells are merged. -----Original Message----- You asked "with wrap text selected" - Do you mean "without wrap text selected"? Once you type the content into a cell and apply wrapping, the row ht. should automatically adjust accordingly unless the ht. was previously increased using a manual technique (such as dragging the row divider or FormatRowHeight). If the height has beenmanually changed, just Double-Click the separator between the row number of that row & the one beneath it. You can also turn text wrap OFF, reset the row height to it's default, then reset text wrap. That should cause the height to automatically adjust as well. HTH |:) HTH |:) "anonymous" wrote: Is there an option to automatically adjust row height to display all the text in a cell with wrap text selected? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Wrap Text won't work | Excel Discussion (Misc queries) | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
how many lines can be in wrap text within a cell? | Excel Worksheet Functions | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
how many lines can be in wrap text within a cell? | Excel Worksheet Functions |