I have a workbook that resides on Sharepoint wherein there's a table that has an INDEX MATCH MATCH to populate information from another location. This information includes line breaks within a cell. I have AutoFit Row Height and Wrapped Text turned on for this column, and there are no merged cells.
When I open the workbook in the desktop version of Excel, the information in those cells looks exactly as one would expect. However, when I open the workbook in Excel Online, the cells only have one visible line of text and anything I do to try to AutoFit Row Height does not work.
This workbook gets manipulated by Power Automate on a regular basis, so I need to get those cells to properly adjust row height on their own to fit the information they contain, just like it does on Desktop. Does anybody have any recommendations for how to go about this?