Problems with displaying all of my text within a cell.

Occasional Visitor

I am entering text in a cell as a Comment line. Sometimes the text would require the cell height to increase to show all the text. How do I set this up automatically so each cell reformats itself to show the complete text entered.  I can change the cell height manually but I am looking for an auto function to do the resizing. Doing it manually is difficult to be consistent and the professional appearance suffers.

 

Any help will be appreciated.

Kindest Regards,

Neal Adams, PhD

1 Reply
Home tab, Format, Autofit row height. But this button does not work on merged cells.