Missing Text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

louseey@officeformac.com - 01 May 2008 16:28 GMT

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I am pretty much a novice using Excel, so I'm not sure if I'm doing something wrong. When I type a lot of text in to a cell, it is all there. Then I save it, close it, and when I reopen the file, a lot of the text is missing, like it's being cut off. Help. Where's it going? Do I need to format each cell or do they resize to fit the the text?

Reply to this Message

JE McGimpsey - 01 May 2008 16:43 GMT

> Version: 2008
> Operating System: Mac OS X 10.4 (Tiger)
[quoted text clipped - 5 lines]
> it's being cut off. Help. Where's it going? Do I need to format each cell or
> do they resize to fit the the text?

While a cell can contain up to 32767 characters, XL can only display or
print the first 1024 characters. You should still be able to see the
rest of the text in the formula bar.

You can get around this limit if you put a manual carriage return
(CMD-OPTION-RETURN) character every 1024 (or fewer) characters.

Reply to this Message

Mac Forum / Applications / Excel / May 2008

Missing Text