Missing text in a cell?

J

Joyce

How do I show all the text in a cell? I have tried the auto-fit options for
both row and column and the wrap alignment option and it still not showing
all the text I have typed. It didn't do it in short paragraphs but with the
longer ones--the last 2-3 sentences are missing.
 
N

Nick Hodge

Joyce

Excel will only display the first 256 characters ina cell, up to 32,000 or
something similar can be displayed in the formula bar. (To check this look
up excel limits in help, sorry I only have a beta on this machine with no
help files)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
J

Joyce

Thanks...

Can I change or adjust that limit..? does it count spaces too?
I find it really odd..I'll check my other spreahsheets and see if they went
over the 256 characters..
 
D

Dave Peterson

Excel's help says that it'll display 1024 characters (all 32767 will appear in
the formula bar).

Joyce, if you add alt-enters (to force new lines within the cell) every 80-100
characters, you'll see far more than the 1024 limit that excel's help gives.
 
J

Joyce

correction: 256-32000 characters in a cell?
i have less than 32000 characters for sure...is there anything else that i
should do? or might have forgotten?
 
Top