Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
anonymous
 
Posts: n/a
Default 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?
  #2   Report Post  
CyberTaz
 
Posts: n/a
Default

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   Report Post  
anonymous
 
Posts: n/a
Default

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
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
Wrap Text won't work rubenwm Excel Discussion (Misc queries) 2 February 4th 05 01:40 AM
Cell set to wrap text and blank line -- fix? Fred Holmes Excel Discussion (Misc queries) 0 January 25th 05 07:10 PM
how many lines can be in wrap text within a cell? pearsms Excel Worksheet Functions 2 December 27th 04 06:11 PM
Concatenation formula loses text wrap formatting DFM Excel Discussion (Misc queries) 5 December 27th 04 01:45 PM
how many lines can be in wrap text within a cell? Pear Excel Worksheet Functions 1 December 27th 04 11:35 AM


All times are GMT +1. The time now is 01:43 AM.

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

About Us

"It's about Microsoft Excel"