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

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.

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?

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!