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...
If you turn on Wrap text for that cell, doesn't that cause Excel to expand the row-height to accommodate for the number of rows of text?
Note that this does not work for merged cells, so you must redesign the sheet so this comment cell is a single cell.
Note that this does not work for merged cells, so you must redesign the sheet so this comment cell is a single cell.
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.
