Row height adjustment after sort

L

Leroy Syrop

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?
 
G

Gord Dibben

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
 
L

Leroy Syrop

Gord Dibben said:
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


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top