Wrap text & row height

  • Thread starter Thread starter anonymous
  • Start date Start date
A

anonymous

Is there an option to automatically adjust row height to
display all the text in a cell with wrap text selected?
 
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
Format>Row>Height).

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 |:>)
 
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
Click to expand...
mean "without wrap text selected"?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

wrapped text in cells not displaying 2
How do I autofit row height to adjust to new text on Excel form? 1
How can I set the row height to adjust to fit wrapped text 4
Wrap around setting won't adjust row hieght 3
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Return to Auto Row Height - 2007 2
Formatting Excel 3
Row Height-Auto Adjust to Content? 5

Back
Top