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?

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

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?

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

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

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

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

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

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

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

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

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

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

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

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 ?

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

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/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Tue, 26 Sep 2006 20:01:03 -0700, Meathead
wrote:

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 ?

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

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.

Gord Dibben wrote:
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/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Tue, 26 Sep 2006 20:01:03 -0700, Meathead
wrote:

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 ?