Forum Discussion
Row adjust not working for merged cells
I am using MS 365 v2102 There is a merged cell that will contain a long text. Typically used for notes. When I touch "wrap text", the merged cell with long text only shows one line. I manual...
Horizontally, just one row. Maybe the problem is with all the merges. Haven't checked
Merged cell have always been problematic, but anyway you still need them for formatting
Merged cell have always been problematic, but anyway you still need them for formatting
If I use Center Across Selection instead of merging cells, Excel automatically fits the row height for me.
There is VBA code to autofit the row height of merged cells, but (a) it is complicated, (b) it works less than perfectly, and (c) it disables Undo.
- I would also use 'Center across Selection' for centred headings, though it makes little difference to ones ability to select an Excel Table column since that does not accept entire column selections.
I wasn't proposing a VBA solution, I had simply used the object model as a source of information on the 'wrap' property. I hope I did not confuse the OP.- I understood you wanted to do some "reverse engineering via VBA" to find out a solution.
In my case the other centred options do no seem to work for me. In fact it is the same solution that was stated at the link.
