xl cells won't display all characters in cell!!! need help!!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LB - 27 Apr 2007 17:33 GMT

I am having difficulties displaying all the text in my xl spreedsheet.
a few cells have a lot of text in them (200+) words so the sentences
get cut off (the are visible if i click on the cell, but I need the
entire sentence to be displayed.

i tried sizing the row and the height and making the text smaller.
also using auto-fit. .... but nothing seems to display the entire
text.

any help with this would be highly appreciated!

thank you,
lilian

Reply to this Message

JE McGimpsey - 27 Apr 2007 18:03 GMT

> I am having difficulties displaying all the text in my xl spreedsheet.
> a few cells have a lot of text in them (200+) words so the sentences
[quoted text clipped - 4 lines]
> also using auto-fit. .... but nothing seems to display the entire
> text.

XL's specifications (search XL Help, "Specifications") are that cells
can contain 32767 characters, but will only display or print 1000
characters. You can bypass this limit in some cases by inserting a line
feed in the first 1023 characters using CMD-OPT-Enter.

Reply to this Message

Mac Forum / Applications / Excel / April 2007

xl cells won't display all characters in cell!!! need help!!!