Forum Discussion
Can row height adjust to fit all wrapped text automatically, or font size adjust to do the same?
I'm working in Office Professional Plus 2019. I've got a workbook that interacts with Power Automate in several ways and I'm having issues getting Excel to do what I want it to. Here's the det...
Why doesn't wrap text work for merged cells? This seems like a massive oversight. Google Sheets allows for this functionality.
Wrap Text does work for merged cells, but Excel won't autofit the height of such cells.
- Correct, I worded my question wrong. Why won't Excel autofit the height of merged cells with wrap text? This is causing massive frustration.
Microsoft never implemented it. You can request it from within Excel: Help > Feedback > Make a suggestion.
And/or vote for Auto fit Row Height with Merged Cells
In the meantime, it is possible to autofit merged cells using VBA in the desktop version of Excel for Windows and Mac. See the attached workbook for an example.
- Thank you. I voted for that post you linked to, and I'll look into VBA. I really wish Microsoft would fix this problem.