About Us

Leroy Syrop[_2_]

"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
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 authors
last name, the authors full name, and the first word of the quote in that
order. The reader sees the quote column and the authors full name; the last
name column is hidden.

For one-line quotes with a one-line authors names I use a 22 pixel (0.18
in) row height. For multi-line quotes or multi-line authors 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 authors name whichever is larger.
Unfortunately, that doesnt always happen. Often after the sort, a long quote
moves into a cell formerly occupied by a small one and the cell height
doesnt enlarge enough to accommodate it. Conversely, when a short quote is
sorted into a large cell it sometimes doesnt fully close down to the proper
height. Both of these €œerrors€ happen inconsistently.

Does anyone have a solution?

.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Row Height Adjustment on data Imported into excel	Lisa	Excel Worksheet Functions	1	September 23rd 09 12:39 AM
Auto Cell Height Adjustment for text entered	Solex	Excel Discussion (Misc queries)	3	June 19th 09 01:18 PM
sort changes row height	Christyr	Excel Discussion (Misc queries)	1	May 14th 09 01:10 AM
ROW HEIGHT ADJUSTMENT IN PIVOT TABLES	d-mitt	Excel Discussion (Misc queries)	0	April 26th 08 04:32 AM
Automatic row height adjustment	nsv	Excel Discussion (Misc queries)	5	January 27th 06 07:38 AM

Menu

About Us