Forum Discussion
SirGeppetto
Jan 11, 2023Copper Contributor
Wrap Text - Return to line doesn't work - Windows 10
As you can see on line F2 I can't return to the line under and my sentence isn't completely display. I tried to unlink F2 and G2 and also to unlink ALL the cells on this sheet but it doesn't work. H...
HansVogelaar
Jan 11, 2023MVP
Excel doesn't autofit the row height of merged cells. You'll have to do that manually (or run a macro for that purpose).
After you unmerge, you should be able to double-click the lower edge of the row number to autofit.
- SirGeppettoJan 11, 2023Copper ContributorI have succesfully done the first one (I don't know how) but I have another line bugged and double clicking at the bottom edge do nothing so I don't know how to wrap even if it's unmerged.
- HansVogelaarJan 11, 2023MVP
AutoFit is far from perfect - sometimes you have to increase (or decrease) the row height manually.
- SirGeppettoJan 11, 2023Copper Contributorok ! I didn't know that I could do it manually, it will be easier as I did for the row width, thank you 🙂