You could add a helper column that contains enough text to insure that
autofitting the rowheight will never be smaller than what's required for the
cell in that column.

You could even hide that column.

Another way is to use an event macro that autofits the rowheight and then
adjusts the rowheight if it's not what you like.

But that event macro would depend on the details.

How is the cell changing--by formula or by manual entry by the user?
How many worksheets in this workbook need this?
What rows/cells need this on each sheet?



Raymond W. wrote:

I have an existing workbook that is used by a large number of people on '03
and '07 (on numerous computers). Until recently, a row height of 25.5 (34
pixels) was adequate (allowed two lines of text), but no longer. I can set
the worksheets to autofit and wrap text in order to grow appropriately and
fit additional lines, but that forces the cells with one line of text to drop
to 12.75 (17 pixels).

This is unacceptable, and I need a minimum cell height of 25.5

Is it possible to change the minimum so autofit won't go below that? I need
it to affect this workbook alone.

--

Dave Peterson