Individual cell heights and widths are a function of the row height and column
width and cannot be larger than the entire row or column.

You are seeing something other than what you describe.

Unless you have two or more merged cells you are typing into.

I tested this..............

Merged A1:A3 then moved row 3 up to cover 1 and 2

Typed into the cell with wrap text set on.

FormatRowAutofit and A1:A3 increased but rows 1, 2 and 3 did not.


Gord Dibben MS Excel MVP

On Tue, 19 Dec 2006 15:32:01 -0800, CW wrote:

If I set a cell to wrap text, the type in several lines, only that one cell
is adjusted in height - the rest of the row stays at the original height
unless I deliberately click on the row line to adjust it to fit.
I tried formatting the whole row to wrap text but that didn't help.
How do I get the whole row to deepen automatically in response to any cell
within that row being increased in height?
Many thanks
CW