Scott,
The problem is that excel does not increase the row height automatically for merged cells to display wrapped data.
Thanks you all for responding.
Evan
Thank you pmover for responding.
The problem is the spreadsheet needs to look like a word document, as this is an official company document. I ended up writing VB code to go around it.
Aging thank you’re input.
I have a protected sheet with merged cells. The cells are formatted to wrap. When the data is larger than the merged cell, the cell does not wrap. You need to unprotect the sheet; then increase the row height to force to wrap. Any
Suggestions on how to force it to wrap automatically?
