Autosize Row Heights

Gord,

No merged cells!! Having spent a bit of time messing around with different
combinations of text, characters and "Alt+Enter's" (Propper name hard
carriage return??) I believe that this is probably related to the cell
limitation you mentioned earlier. Are you certain about "To get around this
1024 limit follow RD's advice and sprinkle some AT +ENTER's in every 1000
chars or so." as I don't believe this works?

Kind Regards

Andi




"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:fhi1819qci51h8o6oj99meu483l2ngle2s@4ax.com...
> Andi
>
> Should have been ALT + ENTER, but I think you noticed that.
>
> Are any cells merged?
>
> Excel has a problem autofitting rows with merged cells.
>
> You can resize manually or via Macro. Jim Rech has written
> code for this.
>
> http://groups.google.com/groups?thre...%40tkmsftngp05
>
> Note also a recent adaptation of this code by Greg Wilson.
>
> http://makeashorterlink.com/?P37D24B15
>
> The best cure is DON"T USE MERGED CELLS. They cause no end of problems
with
> copying, pasting, sorting, filtering.
>
>
> Gord
>
> On Tue, 10 May 2005 11:03:45 +0100, "Andibevan"
> <andibevan@remove-to-prevent-spam-hotmail.com> wrote:
>
> >Gord,
> >
> >It's not the point limit but I think it may be something to do with the
> >visible character per cell limit.
> >
> >I have just done a character count on the visible text (visible text when
> >trying to use row autosize - clicking on line between rows) and it is
> >1,108chars including spaces, 924 without, which is fairly close to 1024.
> >The problem with your solution is that I have already got about 10 of
> >AT+ENTER's in this text already.
> >
> >The cell's height won't autosize to show the entire text, but you can
> >manually size the row heights - this is time consuming though.
> >
> >Regards
> >
> >Andy
> >
> >
> >"Gord Dibben" <gorddibbATshawDOTca> wrote in message
> >news:0vbv711tr9q7b9jo6qokmuul61e00f84uk@4ax.com...
> >> 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"
> >> <andibevan@remove-to-prevent-spam-hotmail.com> 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
> >> >
> >>
> >
>

Andi

Been playing with this and find the following, which is no help to you.

Enter =REPT(REPT("1234567890",12)&CHAR(10),30)

Gives 30 lines of 120 characters in the cell = 3630 chars(including the
CHAR(10)'s

Wrap text is set.

Column width at 121

Format>Row>Autofit shows 17 lines = 2040 characters

Column width at 136

Format>Row>Autofit shows 9 lines = 1080 characters plus whitespace.

Manually fit row height and can see all 3630 characters.

Not much rhyme nor reason as far as I can see.


Gord

On Tue, 10 May 2005 17:43:27 +0100, "Andibevan"
<andibevan@remove-to-prevent-spam-hotmail.com> wrote:

>Gord,
>
>No merged cells!! Having spent a bit of time messing around with different
>combinations of text, characters and "Alt+Enter's" (Propper name hard
>carriage return??) I believe that this is probably related to the cell
>limitation you mentioned earlier. Are you certain about "To get around this
>1024 limit follow RD's advice and sprinkle some AT +ENTER's in every 1000
>chars or so." as I don't believe this works?
>
>Kind Regards
>
>Andi
>
>
>
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:fhi1819qci51h8o6oj99meu483l2ngle2s@4ax.com...
>> Andi
>>
>> Should have been ALT + ENTER, but I think you noticed that.
>>
>> Are any cells merged?
>>
>> Excel has a problem autofitting rows with merged cells.
>>
>> You can resize manually or via Macro. Jim Rech has written
>> code for this.
>>
>> http://groups.google.com/groups?thre...%40tkmsftngp05
>>
>> Note also a recent adaptation of this code by Greg Wilson.
>>
>> http://makeashorterlink.com/?P37D24B15
>>
>> The best cure is DON"T USE MERGED CELLS. They cause no end of problems
>with
>> copying, pasting, sorting, filtering.
>>
>>
>> Gord
>>
>> On Tue, 10 May 2005 11:03:45 +0100, "Andibevan"
>> <andibevan@remove-to-prevent-spam-hotmail.com> wrote:
>>
>> >Gord,
>> >
>> >It's not the point limit but I think it may be something to do with the
>> >visible character per cell limit.
>> >
>> >I have just done a character count on the visible text (visible text when
>> >trying to use row autosize - clicking on line between rows) and it is
>> >1,108chars including spaces, 924 without, which is fairly close to 1024.
>> >The problem with your solution is that I have already got about 10 of
>> >AT+ENTER's in this text already.
>> >
>> >The cell's height won't autosize to show the entire text, but you can
>> >manually size the row heights - this is time consuming though.
>> >
>> >Regards
>> >
>> >Andy
>> >
>> >
>> >"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>> >news:0vbv711tr9q7b9jo6qokmuul61e00f84uk@4ax.com...
>> >> 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"
>> >> <andibevan@remove-to-prevent-spam-hotmail.com> 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
>> >> >
>> >>
>> >
>>
>

Gord,

I think your right - it isn't much help :-) , but it does show that there
probably is a slightly more complex relationship between visible cells,
autofit row height and characters in a cell. I presume that excel documents
its capacity as 1040 because that number of characters will ALWAYS be
displayed.

Thanks for your help

Andy

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:ua1281t42re3apnav7s7r9l574gpnrfi3s@4ax.com...
Andi

Been playing with this and find the following, which is no help to you.

Enter =REPT(REPT("1234567890",12)&CHAR(10),30)

Gives 30 lines of 120 characters in the cell = 3630 chars(including the
CHAR(10)'s

Wrap text is set.

Column width at 121

Format>Row>Autofit shows 17 lines = 2040 characters

Column width at 136

Format>Row>Autofit shows 9 lines = 1080 characters plus whitespace.

Manually fit row height and can see all 3630 characters.

Not much rhyme nor reason as far as I can see.


Gord

On Tue, 10 May 2005 17:43:27 +0100, "Andibevan"
<andibevan@remove-to-prevent-spam-hotmail.com> wrote:

>Gord,
>
>No merged cells!! Having spent a bit of time messing around with different
>combinations of text, characters and "Alt+Enter's" (Propper name hard
>carriage return??) I believe that this is probably related to the cell
>limitation you mentioned earlier. Are you certain about "To get around
this
>1024 limit follow RD's advice and sprinkle some AT +ENTER's in every 1000
>chars or so." as I don't believe this works?
>
>Kind Regards
>
>Andi
>
>
>
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:fhi1819qci51h8o6oj99meu483l2ngle2s@4ax.com...
>> Andi
>>
>> Should have been ALT + ENTER, but I think you noticed that.
>>
>> Are any cells merged?
>>
>> Excel has a problem autofitting rows with merged cells.
>>
>> You can resize manually or via Macro. Jim Rech has written
>> code for this.
>>
>> http://groups.google.com/groups?thre...%40tkmsftngp05
>>
>> Note also a recent adaptation of this code by Greg Wilson.
>>
>> http://makeashorterlink.com/?P37D24B15
>>
>> The best cure is DON"T USE MERGED CELLS. They cause no end of problems
>with
>> copying, pasting, sorting, filtering.
>>
>>
>> Gord
>>
>> On Tue, 10 May 2005 11:03:45 +0100, "Andibevan"
>> <andibevan@remove-to-prevent-spam-hotmail.com> wrote:
>>
>> >Gord,
>> >
>> >It's not the point limit but I think it may be something to do with the
>> >visible character per cell limit.
>> >
>> >I have just done a character count on the visible text (visible text
when
>> >trying to use row autosize - clicking on line between rows) and it is
>> >1,108chars including spaces, 924 without, which is fairly close to 1024.
>> >The problem with your solution is that I have already got about 10 of
>> >AT+ENTER's in this text already.
>> >
>> >The cell's height won't autosize to show the entire text, but you can
>> >manually size the row heights - this is time consuming though.
>> >
>> >Regards
>> >
>> >Andy
>> >
>> >
>> >"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>> >news:0vbv711tr9q7b9jo6qokmuul61e00f84uk@4ax.com...
>> >> 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"
>> >> <andibevan@remove-to-prevent-spam-hotmail.com> 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
>> >> >
>> >>
>> >
>>
>