FORMAT-CELL-ALIGNMENT

[SuperLC]

When I merge two cells and the data in the merged cell is very long, the merged cell will not automatically wrap even though I have turned on the wrap-text option. How can I "fix" this so that the wrap function continues to operate even though two or more cells have been merged?

 

[Biff]

Are you sure it's not wrapping? It works for me. Did you
adjust the cell height?

Biff

-----Original Message-----
When I merge two cells and the data in the merged cell is

very long, the merged cell will not automatically wrap
even though I have turned on the wrap-text option. How can
I "fix" this so that the wrap function continues to
operate even though two or more cells have been merged?

 

[SuperLC]

No, I did not adjust the height. Thing is, I want the function to operate automatically without me having to manually adjust the height. When you turn on the function in a single cell and you type a long message in that cell, the function will automatically adjust the height of the cell to fit the contents (assuming of course that you have pre-set the width of the cell). But when you merge two cells horizantally into one cell, the function does not work.

Anyway, many many thanks for responding! ;-)

 

[JE McGimpsey]

First, functions can't change cell heights.

Second, merged cells with wrap text won't autosize. You can use Jim
Rech's macro to simulate autosizing:

http://google.com/groups?selm=uGMQVjd0CHA.2296@TK2MSFTNGP10

To automate it you can modify it to be called from the Worksheet_Change
event macro. Post back if you need help.

However, if it's possible to avoid using merged cells, you're far better
off. They're the spawn of the devil, and make sorting, filtering and
formatting much more difficult than they're worth.

 

[SuperLC]

Thanks heaps for the tip. I finally decided to do away with using merged cells and reverted to single cells (for the same reasons you pointed out below!).

Take care, and thanks again ...