Excel Text Wrapping Problem

[robo]

Hello,

I have worked with Excel (97 through 2007) for years but brand new to the
Mac OSX and Excel 2004.

I was given a spreadsheet that has cells that will not wrap. There is TONS
of data though. This is a small example....One Cell has 174 Words and 1481
Characters. Some have more.

Wrapping is turned on and my my row height is adjusted.

If I keep expanding my row height it won't wrap. It just shows blank lines.

Does this make sense? Suggestions

Thanks

 

[JE McGimpsey]

Hello,

I have worked with Excel (97 through 2007) for years but brand new to the
Mac OSX and Excel 2004.

I was given a spreadsheet that has cells that will not wrap. There is TONS
of data though. This is a small example....One Cell has 174 Words and 1481
Characters. Some have more.

Wrapping is turned on and my my row height is adjusted.

If I keep expanding my row height it won't wrap. It just shows blank lines.

Does this make sense?

Yes.

This problem is the same for XL97-2003, and MacXL98-2004. Look at XL
Help ("Specifications"). Only the first 1024 characters will display in
the cell or when printed.

You can get around that if you put a hard line feed (CTRL-OPT-RETURN) at
least every 1024 characters (up to the limit of 32767).

 

[robo]

Thank you! I just learned something new.

Yes.

This problem is the same for XL97-2003, and MacXL98-2004. Look at XL
Help ("Specifications"). Only the first 1024 characters will display in
the cell or when printed.

You can get around that if you put a hard line feed (CTRL-OPT-RETURN) at
least every 1024 characters (up to the limit of 32767).