autofit row height with wrap text not working for cells using a formula

Highlighted
New Contributor

I have a workbook with multiple sheets that use an index formula. I have cells with the index formula formatted to wrap text and have autofit the row height. When the formula returns data it does not automatically adjust the row height. I am able to select the row and autofit, and then it will adjust the row height. If I remove the data that is indexed, it does not shrink back down when that cell does show anything. If I get rid of the formula and type manually, it will wrap and adjust the row height automatically.

 

How can I get this to work and still use my formulas?

1 Reply
Highlighted
I'm afraid all you can do is write VBA code to handle this.