Auto-size cell (in height) while entering data.

[craigwojo]

I know I can go to format and autofit row height, but is there a way to automatically fit the text while I'm typing or after I've finished working with the cell?
If it is a macro, could it be used for all cells?

Thank you and God bless,
Craig

 

[craigwojo]

I just found out that it does work with pre-formatting the cells with autofit row height.