Row height to auto-adjust for wrapped text
 

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

Row height to auto-adjust for wrapped text
 

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

Row height to auto-adjust for wrapped text
 

"Seeing something other than what I describe"??
Well I know Excel can cause all kinds of scenarios but I didn't think it
went as far as hallucination!
You're right, of course. It was the merged cells that messed it up. Should
have thought of that. Undid those, works fine.
Thanks for putting me straight.
CW

"Gord Dibben" wrote:

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

Row height to auto-adjust for wrapped text
 

Yes CW you are right I have the same problem, hope some one will solve.

regds.
Samad

"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

Row height to auto-adjust for wrapped text
 

Did not mean to suggest you were hallucinating.

Poorly worded......should have said "what you are seeing is not normal
behaviour"

Thanks for the feedback.


Gord

On Tue, 19 Dec 2006 16:26:01 -0800, CW wrote:

"Seeing something other than what I describe"??
Well I know Excel can cause all kinds of scenarios but I didn't think it
went as far as hallucination!
You're right, of course. It was the merged cells that messed it up. Should
have thought of that. Undid those, works fine.
Thanks for putting me straight.
CW

"Gord Dibben" wrote:

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



Gord Dibben MS Excel MVP