Andi

Row height autosize is not limited to <14 rows of text. A row height is
limited to 409 points(72 points to the inch).

What you are most likely running into is the limits on viewable text in a
cell.

From Help on Specifications you will find that 32767 characters can be entered
in a cell.

However, only 1024 of these will be seen or can be printed.

To get around this 1024 limit follow RD's advice and sprinkle some AT +
ENTER's in every 1000 chars or so.

Postings have indicated that you can increase the 1024 up to several thousand.

Another work-around is to use a Text Box to store the text.


Gord Dibben Excel MVP

On Mon, 9 May 2005 15:55:43 +0100, "Andibevan"
wrote:

Hi All,

From my understanding, Excel's autosize feature for row heights has some
limitations as it only works on rows with 14 or less lines of text in a
cell.

I have two questions:-

1) Can anyone confirm the specifics of these limitations
2) Does anyone have any good ideas on how to workaround this (I am aware
that you can manually resize each row but as my sheet has over 700 entries
this would not be useable).

Any help or pointers would be gladly received.

Andi