Why won't my text fully display with word-wrap and merged cells?

[Guest]

I am using Excel 2000. I have a merged cell (6 cells wide and 1 deep) with a
paragraph of text with word wrap enabled. After about 7 or 8 lines of text
the text does not word wrap anymore. It would be about 2 more lines.

Any ideas?

 

[Guest]

Try enlarging the cell a bit and see if the rest of the text shows up.

 

[Turquoise_dax]

You can always manually set the row height by dragging the row headers.
This sometimes happens to me when the data in this cell contains a text
with a paragraph jump: even with the auto-fit, it sometimes doesn't grab
the whole text. I don't really know why, but setting it manually works
fine for me.

 

[Dave Peterson]

Try adding alt-enters (to force new lines within the cell) every 80-100
characters.

You'll have to adjust the rowheight manually, though.

 

[Guest]

Thanks for all the replys guys but none of these wored.

 

[Dave Peterson]

How many alt-enters did you add?
How long is the text in the cell?
Did you adjust the rowheight manually?

This has worked for me to see at least 5000 characters in a cell.

 

[Turquoise_dax]

If you did set it manually and text is not there, I guess you merged the
cells with more than one cell having data, and you simply lost some of
it as the merging of many cells with data keeps only the text of one
cell!

 

[Guest]

I am having the same problem as Will DeLoach.

I have identified the problem to be :
auto row height does not work on merged cells.

If in there are unmerged columns in same row, the auto height will work on
the unmereged cells.

I have tried to do an auto height by highlighting row and clicking on row
hight, this also does not work.

It is really annoying to have to adjust height manually, as this needs to be
done regularly and if you do a global auto adust row hight, the manual row
height reverts back.

Does anybody have an easy work around that does not involve manual
adjustment of row height ?

 

[Gord Dibben]

You could use event code to autofit the rows with the merged cells.

OR....you coud get rid of the merged cells which can cause no end of problems
with copying, sorting, pasting, filtering and as you have
learned.....autofitting.

The code can be found here.

http://groups.google.com/group/micr...60cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874


Gord Dibben MS Excel MVP

 

[kdflorea]

I am currently experiencing the same problem with Excel only wrapping
certain lines within a cell. This originally occured in a merged cell,
but I experienced the same problem when working with an unmerged cell.
I generally choose to use merged cells for this template because single
row does not provide enough vertical space to meet my needs. I don't
think this is related to the height of the row because manually
adjusting the row height before or after entering the text does not fix
the problem. Hopefully there are other solutions out there somewhere.