ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wrap text & row height (https://www.excelbanter.com/excel-discussion-misc-queries/15915-wrap-text-row-height.html)

anonymous

Wrap text & row height
 
Is there an option to automatically adjust row height to
display all the text in a cell with wrap text selected?

CyberTaz

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?


anonymous

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?

.



All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com