Forum Discussion
James20202020
Dec 22, 2020Copper Contributor
AutoFit row height with wrap text not working on 2016 Excel
For some reason my autofit is not working on my 2016 Excel. I have typed multiple lines in a merged cell and have clicked wrap text. After finishing, the row height does not adjust and I can only see ...
SergeiBaklan
Dec 22, 2020Diamond Contributor
Merged cells is the source of many issues.
If you use Center Across Selection instead with Wrap text row will be automatically expanded
- aquigley1Oct 23, 2024Brass ContributorI have the same error and "Center Across Selection" didn't change anything. Also, I need it aligned left, not centered, so even if this had corrected the text wrap, it wouldn't have worked. Is there another solution?
- HansVogelaarOct 23, 2024MVP
You have asked the same question in four different discussions. That leads to confusion and duplication.
- aquigley1Oct 23, 2024Brass ContributorSince this question is being asked repeatedly (not by me but by multiple other users), it seems Microsoft needs to work on this. I wanted to ask the question on each thread in case someone answered on one thread but not another. I apologize for the duplication.
- rduprasDec 26, 2020Copper Contributor
SergeiBaklan - so strange that not having it work for all alignments. That the default is set for center makes no sense either. The unusual thing is that it works for my work computer but not the new laptop. Is there another setting?