Excel Text Wrapping Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

robo@gobluemail.com - 17 Aug 2007 02:10 GMT

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

Reply to this Message

JE McGimpsey - 17 Aug 2007 05:37 GMT

In article <3C11E968-F629-44CB-8B4F-DA7B034C5472@microsoft.com>,
robo@gobluemail.com <robogobluemailcom@discussions.microsoft.com>
wrote:

> Hello,
>
[quoted text clipped - 10 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).

Reply to this Message

robo@gobluemail.com - 17 Aug 2007 14:24 GMT

Thank you! I just learned something new.

> In article <3C11E968-F629-44CB-8B4F-DA7B034C5472@microsoft.com>,
> robo@gobluemail.com <robogobluemailcom@discussions.microsoft.com>
[quoted text clipped - 23 lines]
> 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).

Reply to this Message

Mac Forum / Applications / Excel / August 2007

Excel Text Wrapping Problem