Forum Discussion
FraserLittle
Aug 12, 2022Copper Contributor
Can I get "Wrap Text" to Automatically autofit row height on a cell containing a formula?
Hi there, Using excel for the web, I have a page that looks up various different sheets (all in the same workbook) based on a unique identifier in cell B4. As an example, a cell contains the fol...
SergeiBaklan
Aug 12, 2022Diamond Contributor
Formulae return the value, not cell properties like colour or wrap text. To play with latest that's VBA or Office Scripts, depends on version/platform.
FraserLittle
Aug 15, 2022Copper Contributor
Hi SergeiBaklan
Thank you for your response.
The problem is the formula could return a one word answer, or could return a paragraph. How can I make the cell adjust height automatically to fit the text displayed so the full text is visible to the user?
Thank you.
Kind Regards,
Fraser Little