Text in cell

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

When I fill a cell with text, I end up not seeing all the
typed text that shows in the address bar. Even if I make
the cell higher, it does not allow for more text. I want
to maintain the width I have, but increase heigth if need
be. Is the amount of text allowed in a cell predetermined,
or can I get more to show in the cell?
 
Click on the cell you want to allow more text in. Then
right click on the cell. Got to Format Cell, click on
the alignment tab, then click on wrap text (make sure the
wrap text box is checked), then click the OK button.
Your information in the cell will word wrap. You can
alway use the shrink to fit option just below word wrap.
That option may make you text to small to read. The
choice is yours... Scott...
 
I have the same problem.
I did some googling and found out that this is due to the fact that
excel doesn't handle texts larger then 1000 characters properly.
It will only show about 1000 characters in a cell. Also, wordwrap only
works for the first 1000 chars.

You can add some alt-enters (to force a new line within the cell), but
that's not a very nice solution.
I need to make a large excel sheet for a library, that wants to store
large descriptions (>5000 chars) per book and don't want to use a
database, but i can't find a solution anywhere
 
I've got the same problem. On the Microsoft Support site,
I found a tech article with the specs on the issue
(http://support.microsoft.com/default.aspx?scid=kb;en-
us;211580&Product=xlw2K), and it includes a quote "Note:
You may be able to see more than 1,024 characters by
increasing the row height and column width of the
worksheet, or by modifying the display settings of the
system." I'm at a loss. We all know that modifying the
width and height of the cell won't help, and I'm not sure
what display settings to modify. I think this cryptic MS
message may be my only hope - any ideas?
 
Not sure why that note was included - AFAIK, it's incorrect.

Either use alt-Enter or, preferably, use the right tool for the job
- a database.
 
Back
Top