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?

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

"Will DeLoach" wrote:

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?

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.


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=556464

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

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

Will DeLoach wrote:

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?

--

Dave Peterson

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


"Dave Peterson" wrote:

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

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

Will DeLoach wrote:

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?

--

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.

Will DeLoach wrote:

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

"Dave Peterson" wrote:

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

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

Will DeLoach wrote:

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?

--

Dave Peterson


--

Dave Peterson

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!


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=556464

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 ?