Text not fitting in a cell

B

bmondello

Can anyone explain why the text i am typing in the cell
shows all in the formula box, but when I move to another
cell, no all the text is visible? It chops off the ast
couple of sentences. I have tried all the standard
actions,like formatting the the cell, text wrap, enlarge
the cell both thru coumn width and row ht, but nothing
seems to work. It is like their is a setting that only
allows so many words in a cell.
Any guidance here?

I have excel 2000
Thanks,
please frespond to my e mail : (e-mail address removed)
Thanks
 
A

Arvi Laanemets

Hi

MS Help: Worksheet and workbook specificatiions
Length of cell contents (text) - 32,767 characters. Only 1,024 display
in a cell; all 32,767 display in the formula bar.
 
F

Frank Kabel

Hi
in addition to Arvi's answer: You can extend the displayed amount of
text if you add manual linebreaks with ALT+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