Note: I'm unable to use VBA/Macros unfortunately.
Is there a way to make the height of rows adjust automatically as their cell contents change?
I have a sheet with formulae that return data based on some other variables, and the results can range from 2-3 words to a full paragraph. I'd like to make it so that row heights adjust with the changing data, as making the rows large enough to accommodate the large amounts of text looks ridiculous when the result is just a few words.
Format Cells -> Alignment -> Wrap text
)