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

L

LB

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
 
J

JE McGimpsey

LB said:
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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top