I'm inserting short paragraphs into cells (copied from a text editor -- so no URLs, no special characters). The cells are set to word wrap, and I've tried changing the vertical alignment, but that has had no effect.
The problem: some of the cells resize automatically and display the text. Others in the same column do not.
I know I can resize the rows, but that seems kind of clunky. Is there a secret setting that will automatically increase the row height as necessary?
I've tried Brad's solution from http://www.vbaexpress.com/kb/getarticle.php?kb_id=421
but while it did set the text to a specific WIDTH, it didn't change the row height.