Auto fit merged cells
 

I have a merged cell that merged horizontally and mapped to another cell. I
updated the source with a longer sentence and the merged cell looked up from
it fine but the height of the cells will not adjust to the proper height so
it only shows a portion of the sentence on the worksheet.

Is there a way to automatically adjust the height of the cell so when I
update the source, the height of the designation will increase or decrease to
fit the full sentance?

Thanks for your help. I am currently using MS Excel xp

Anson

Merged cells will allow "wrap text" from FormatCellsAlignment but..........

Excel has a problem auto-fitting merged cells.

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

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

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

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 Mon, 20 Dec 2004 13:01:02 -0800, "Anson"
wrote:

I have a merged cell that merged horizontally and mapped to another cell. I
updated the source with a longer sentence and the merged cell looked up from
it fine but the height of the cells will not adjust to the proper height so
it only shows a portion of the sentence on the worksheet.

Is there a way to automatically adjust the height of the cell so when I
update the source, the height of the designation will increase or decrease to
fit the full sentance?

Thanks for your help. I am currently using MS Excel xp