maximum row height

[Guest]

I can't read all the text in a cell. I have the text wrapping on. I first
tried to autofit, but it didn't work. Then I tried to manually increase the
row height but it doesn't let me go more than 546 pixels. Is that the maximum
row height? If not, do you know why it is not working?
Thanks

 

[Guest]

Instead of using autofit or text wrapping, use Edit-->Fill-->Justify

This will use multiple cells and will extend below the curent cell.

See if this serves your needs.


Manoj

 

[Gord Dibben]

Maria

Excel Help on "limits" or "specifications" reveals that Excel will allow
32,767 characters to be entered in a cell.

However, it goes on to state that "only 1024 characters will be visible or can
be printed"

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

I can't read all the text in a cell. I have the text wrapping on. I first
tried to autofit, but it didn't work. Then I tried to manually increase the
row height but it doesn't let me go more than 546 pixels. Is that the maximum
row height? If not, do you know why it is not working?
Thanks

Gord Dibben MS Excel MVP