Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dactivant
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
Dactivant
 
Posts: n/a
Default 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!!!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Control - Wrap Text SF Excel Discussion (Misc queries) 2 February 6th 06 02:22 PM
Just one cell in an Excel column won't text wrap. Kathleen New Users to Excel 1 January 21st 06 08:28 PM
Resizing row height to dynamically fit height of text box Jon Excel Discussion (Misc queries) 1 August 8th 05 01:37 PM
Wrap text ceases to function in Excel if cell exceeds 9 lines nycemail Excel Worksheet Functions 1 July 24th 05 06:09 PM
text wrap in merged cells SteveFerd Excel Discussion (Misc queries) 3 July 16th 05 12:46 PM


All times are GMT +1. The time now is 11:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"