Automatically set rows with cells with text wrapping to change hei
 

When formatting a cell with text wrapping, the row is not automatically
increasing in height to account for extra text. Therefore, some text is
hidden. Is there something that can be done while formatting for wrapping so
that this will not occur.

Automatically set rows with cells with text wrapping to change hei
 

Do you have any "merged" cells in the rows?

Autofit does not work on wrapped text in "merged" cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?thre...%40tkmsftngp05

Also revised code for special cases.

http://snipurl.com/dfsm


The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.


Gord Dibben Excel MVP


On Wed, 7 Dec 2005 11:50:01 -0800, cbizic
wrote:

When formatting a cell with text wrapping, the row is not automatically
increasing in height to account for extra text. Therefore, some text is
hidden. Is there something that can be done while formatting for wrapping so
that this will not occur.

Automatically set rows with cells with text wrapping to change
 

Hello,

Thanks for the information. There are merged cells in other rows above this
in the columns that the row appears in (But not in the row the problem is
occurring in). Would this affect it?

cb

"Gord Dibben" wrote:

Do you have any "merged" cells in the rows?

Autofit does not work on wrapped text in "merged" cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?thre...%40tkmsftngp05

Also revised code for special cases.

http://snipurl.com/dfsm


The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.


Gord Dibben Excel MVP


On Wed, 7 Dec 2005 11:50:01 -0800, cbizic
wrote:

When formatting a cell with text wrapping, the row is not automatically
increasing in height to account for extra text. Therefore, some text is
hidden. Is there something that can be done while formatting for wrapping so
that this will not occur.

Automatically set rows with cells with text wrapping to change
 

I just experimented with this scenario.

Merged a few cells in rows above.

Put some text into a cell in a row below these.

Wrap text and Autofit work OK on that row.

Do you get any movement at all when you autofit that row or does it absolutely
refuse to change height?

If that row has been manually set to a height, it won't re-size until you go
back and re-format to Autofit.


Gord Dibben Excel MVP

On Thu, 8 Dec 2005 07:58:03 -0800, cbizic
wrote:

Hello,

Thanks for the information. There are merged cells in other rows above this
in the columns that the row appears in (But not in the row the problem is
occurring in). Would this affect it?

cb

"Gord Dibben" wrote:

Do you have any "merged" cells in the rows?

Autofit does not work on wrapped text in "merged" cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?thre...%40tkmsftngp05

Also revised code for special cases.

http://snipurl.com/dfsm


The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.


Gord Dibben Excel MVP


On Wed, 7 Dec 2005 11:50:01 -0800, cbizic
wrote:

When formatting a cell with text wrapping, the row is not automatically
increasing in height to account for extra text. Therefore, some text is
hidden. Is there something that can be done while formatting for wrapping so
that this will not occur.