I am creating an Excel sheet with the python openpyxl library (which is extremely cool and useful). The sheet contains two columns of some fixed, preset width which contains text. The format of these columns is set to auto-wrap, so if the text is longer than what fits into the width, it will autowrap into several lines and the height of the row should adapt accordingly. The problem is that after creating the file and loading into Excel or Office online, the rows only show a single, truncated line, with a tiny triangle at the right indicating that the text is overflowing. The only way to actually show this properly is by manually selecting the cells and doing "Autofit Row Height". This is extremely annoying and somewhat defying the idea of creating the sheet programmatically. Is there any way to tell Excel to automatically show the wrapped texts with the correct column heights when loading? Is there some other workaround to achieve this that anyone could point me to (some kind of on-load macro I could set or some other way?) Are there other ways to programmatically create a sheet where it is possible to do this directly?