wrapping text in merged cells

[Elizabeth Ramsay]

Please help! I have developed a spreadsheet for different
people to use to report to my organization. There are
several places where I have merged cells and need to allow
for the possibility of long strings of text being
entered. In the "format cells, alignment" tab, I have
both merge cells and wrap text checked- and IT DOES NOT
WRAP. Other places on my sheet, where I have single cells
for text entry, I have checked the wrap box and it works...
Can anybody help?

 

[Tom Ogilvy]

As you have observed, wrapping does not work for merged cells.

You would need to use code to do this - is that an option?

 

[Tom Ogilvy]

Let me clarify - wrapping works, but autosizing the height does not - which
I assume is the real problem you are describing.

 

[Elizabeth Ramsay]

Yes, this is true. I can get the text to show as wrapped
by manually increasing the row height, but I was hoping to
avoid that.

When you say code- what does this involve?

 

[Dave Peterson]

Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm