ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need help setting row height with wrap text. (https://www.excelbanter.com/excel-discussion-misc-queries/79818-need-help-setting-row-height-wrap-text.html)

Dactivant

Need help setting row height with wrap text.
 
OK. I am trying to create a table that can be copied and pasted. I have some
text in some fields that wraps using text wrap. But when I highlight the row
to use the autofit function, the row height compresses and the text is not
readable, it gets cut off at the top and the bottom.

What am I doing wrong?

Sloth

Need help setting row height with wrap text.
 
are the cells merged? Autofit won't apply to merged cells. You can however
place some alt+enters in a blank cell next to it to match the height. I know
it's a pain, but that is the only solution I have discovered.

"Dactivant" wrote:

OK. I am trying to create a table that can be copied and pasted. I have some
text in some fields that wraps using text wrap. But when I highlight the row
to use the autofit function, the row height compresses and the text is not
readable, it gets cut off at the top and the bottom.

What am I doing wrong?


Dactivant

Need help setting row height with wrap text.
 


"Dactivant" wrote:

OK. I am trying to create a table that can be copied and pasted. I have some
text in some fields that wraps using text wrap. But when I highlight the row
to use the autofit function, the row height compresses and the text is not
readable, it gets cut off at the top and the bottom.

What am I doing wrong?


OK, I found something I could do to get around this. Since some of my rows
were different heights, I set all my rows to a specified height allowing the
lines with the most text to be readable. Other rows are a little tall, but
this way, my main objective to copy and paste tables is met. Thanks anyway
for the advice!!!


All times are GMT +1. The time now is 07:13 PM.

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