7 text lines per cell maximum?

  • Thread starter Thread starter Larry Wahlers
  • Start date Start date
L

Larry Wahlers

Hello,

I am trying to format a spreadsheet in Excel 2003 so I can read all
the text in all the cells. The problem is, even though I set the text
to word wrap, if there are more than 7 lines of text in a given cell,
the last line won't wrap, and I have to click on each individual cell
to read all the text. And, of course, printing the worksheet won't
give me all the text, either.

How can I view all the text, even over 7 lines per cell?

Thanks in advance!



Larry Wahlers
Concordia Technologies
The International Center
The Lutheran Church - Missouri Synod
St. Louis, Missouri USA
 
try entereing some manual linebreaks with ALT+ENTER

Thanks for your reply! I had already tried that, but the resulting new
line didn't wrap, either - just stayed as one long line. Looking at
the spreadsheet, all 88 pages of it, it seems that no cell can contain
more than 7 lines of text. I'm wondering if this is a limitation in
Excel?



Larry Wahlers
Concordia Technologies
The International Center
The Lutheran Church - Missouri Synod
St. Louis, Missouri USA
 
Hi
there's a limitation for displaying characters in one cell (1.024). See
the Excel help for 'specification'
 
There is *no* 7 line per cell limitation in XL.
There is a limit however, to the number of characters a cell can contain.

AFAIK, 1024 characters per line (same as formula length).
So, <Alt> <Enter> after 1023 characters should allow you more capacity.

Just how long is each one of your lines?

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Larry Wahlers said:
try entereing some manual linebreaks with ALT+ENTER
Click to expand...

Thanks for your reply! I had already tried that, but the resulting new
line didn't wrap, either - just stayed as one long line. Looking at
the spreadsheet, all 88 pages of it, it seems that no cell can contain
more than 7 lines of text. I'm wondering if this is a limitation in
Excel?



Larry Wahlers
Concordia Technologies
The International Center
The Lutheran Church - Missouri Synod
St. Louis, Missouri USA
 
Larry

Excel Help states that "a cell can contain 32,767 characters but only 1024
will be visible or can be printed."

If you set the cell to wrap-text and place some ALT + ENTERS after every few
hundred characters you can get some more characters in the cell.

Before you take Help or my suggestion literally you may find some
enlightenment regarding the limitations of text in a cell in this google
search result.

http://snurl.com/26vl

Gord Dibben Excel MVP
 
You've added alt-enters?
you've adjusted wrap text (format|cells|alignment|wraptext)?

My guess:

Any chance that you manually changed the rowheight? If you change it manually,
then excel won't adjust it automatically when you change the value in the cell.

Either autofit the rowheight or make it larger.
 
Excel Help states that "a cell can contain 32,767 characters but only 1024
will be visible or can be printed."
Click to expand...

Thank you, thank you, thank you! That answer addresses my question.
Before you take Help or my suggestion literally you may find some
enlightenment regarding the limitations of text in a cell in this google
search result.

http://snurl.com/26vl
Click to expand...


And, that little page gives ideas on how to do what MS says can't be
done. Thanks again.



Larry Wahlers
Concordia Technologies
The International Center
The Lutheran Church - Missouri Synod
St. Louis, Missouri USA
 
Back
Top