Prev: Changing format of number icon in Excel 2007 toolbar
Next: 01/00/00 appearing before date entered
From: Leroy Syrop Leroy on 9 Feb 2010 04:39
My problem involves the options row height and wrap text using Excel. I have
published a book of quotations distributed free on the internet.

As I add quotes I republish and am now up to the 5th edition. Ideally, I
should be able to add new quotes as I accumulate them and then when I have
enough to warrant a new edition simply sort the three columns by the author's
last name, the author's full name, and the first word of the quote in that
order. The reader sees the quote column and the author's full name; the last
name column is hidden.

For one-line quotes with a one-line author's names I use a 22 pixel (0.18
in) row height. For multi-line quotes or multi-line author's names, that row
height value should expand in multiples of 0.18 with wrap text to accommodate
the number of lines in the quote or the author's name whichever is larger.
Unfortunately, that doesn't always happen. Often after the sort, a long quote
moves into a cell formerly occupied by a small one and the cell height
doesn't enlarge enough to accommodate it. Conversely, when a short quote is
sorted into a large cell it sometimes doesn't fully close down to the proper
height. Both of these “errors” happen inconsistently.

Does anyone have a solution?

From: Gord Dibben on 9 Feb 2010 12:25
You can have rows autofit or be a set height.

You cannot have both.

Not what I would consider as "errors".

If you set all rows to wraptext and autofit you should not see your problem
occur.


Gord Dibben MS Excel MVP


On Tue, 9 Feb 2010 01:39:01 -0800, Leroy Syrop <Leroy
Syrop(a)discussions.microsoft.com> wrote:

>My problem involves the options row height and wrap text using Excel. I have
>published a book of quotations distributed free on the internet.
>
>As I add quotes I republish and am now up to the 5th edition. Ideally, I
>should be able to add new quotes as I accumulate them and then when I have
>enough to warrant a new edition simply sort the three columns by the author�s
>last name, the author�s full name, and the first word of the quote in that
>order. The reader sees the quote column and the author�s full name; the last
>name column is hidden.
>
>For one-line quotes with a one-line author�s names I use a 22 pixel (0.18
>in) row height. For multi-line quotes or multi-line author�s names, that row
>height value should expand in multiples of 0.18 with wrap text to accommodate
>the number of lines in the quote or the author�s name whichever is larger.
>Unfortunately, that doesn�t always happen. Often after the sort, a long quote
>moves into a cell formerly occupied by a small one and the cell height
>doesn�t enlarge enough to accommodate it. Conversely, when a short quote is
>sorted into a large cell it sometimes doesn�t fully close down to the proper
>height. Both of these �errors� happen inconsistently.
>
>Does anyone have a solution?

From: Leroy Syrop on 10 Feb 2010 19:31


"Gord Dibben" wrote:

> You can have rows autofit or be a set height.
>
> You cannot have both.
>
> Not what I would consider as "errors".
>
> If you set all rows to wraptext and autofit you should not see your problem
> occur.
>
>
> Gord Dibben MS Excel MVP
>
>
> On Tue, 9 Feb 2010 01:39:01 -0800, Leroy Syrop <Leroy
> Syrop(a)discussions.microsoft.com> wrote:
>
> >My problem involves the options row height and wrap text using Excel. I have
> >published a book of quotations distributed free on the internet.
> >
> >As I add quotes I republish and am now up to the 5th edition. Ideally, I
> >should be able to add new quotes as I accumulate them and then when I have
> >enough to warrant a new edition simply sort the three columns by the author's
> >last name, the author's full name, and the first word of the quote in that
> >order. The reader sees the quote column and the author's full name; the last
> >name column is hidden.
> >
> >For one-line quotes with a one-line author's names I use a 22 pixel (0.18
> >in) row height. For multi-line quotes or multi-line author's names, that row
> >height value should expand in multiples of 0.18 with wrap text to accommodate
> >the number of lines in the quote or the author's name whichever is larger.
> >Unfortunately, that doesn't always happen. Often after the sort, a long quote
> >moves into a cell formerly occupied by a small one and the cell height
> >doesn't enlarge enough to accommodate it. Conversely, when a short quote is
> >sorted into a large cell it sometimes doesn't fully close down to the proper
> >height. Both of these “errors” happen inconsistently.
> >
> >Does anyone have a solution?
>
> .
>
 | 
Pages: 1
Prev: Changing format of number icon in Excel 2007 toolbar
Next: 01/00/00 appearing before date entered