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 manually make the row several lines tall. If I re-wrap it goes back to 1.
Wrap text is not working with merged cells. It assigns only a line tall.
Please, identify basic functionality issues first.
I tried a similar post for 2016 but it is a different thing.
11 Replies
Please use Excel add-in "AutoFitRowEx".
This add-in will solve the issue.
[Github - Releases · toowaki/AutoFitRowEx]
This is one of the many reasons you should avoid merging cells.
Are your cells merged horizontally (i.e. in a row), or merged vertically (i.e. in a column), or both?
- 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 formattingIf 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.
