wrapping text in merged cells

  • Thread starter Thread starter Elizabeth Ramsay
  • Start date Start date
E

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?
 
As you have observed, wrapping does not work for merged cells.

You would need to use code to do this - is that an option?
 
Let me clarify - wrapping works, but autosizing the height does not - which
I assume is the real problem you are describing.
 
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?
 
Back
Top