Excel - Change cell display limitations

A

AmnNkD

Does anyone know if there is any way to expland the limitations set to
display the number of characters in a cell. I understand that the cell can
contain over 32,000 characters but it only displays barely over 1,000. Can
this be changed? Any assistance would be appreciated.
 
G

Gord Dibben

To work around this limitation, stick a few ALT + ENTERs in at appropriate
spots, about every 100 characters..

The ALT + ENTER forces a line-feed and expands the 1024 limit.

How far is not really known. Just experiment.

.........From Dave Peterson..........

I put this formula in A1:
="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy"

And adjusted the columnwidth, rowheight and font size and I got about 7300
characters to print ok.

.........End Dave P.................

Failing that, use a Text Box to store the text or MS Word which is a word
processing application, unlike Excel which is not.


Gord Dibben Excel MVP

Does anyone know if there is any way to expland the limitations set to
display the number of characters in a cell. I understand that the cell can
contain over 32,000 characters but it only displays barely over 1,000. Can
this be changed? Any assistance would be appreciated.
Click to expand...

Gord Dibben MS Excel MVP
 
A

AmnNkD

Thank you for the information. I discovered that using the ALT + ENTER every
100 characters, the cell will display 2,485 charachters. You have to adjust
the height, and when the row height is at 409.50 (the maximum) the cell will
not display any more characters.

Thank you again!
 
Top