I decided to write this blog post because in doing my analytic research on my blog from a hundred years ago - http://www.knowledgeworkerblog.com that this has been my most popular post - http://www.knowledgeworkerblog.com/2008/10/make-cells-grow-when-you-type-in.html.
I posted it in Excel 2007 version years ago because it was relevant and a great trick. I wonder how many people need it today.
Make cells grow when you type in Microsoft Excel
Watch this video on Lynda.com on aligning text in Excel. Great skills every one who uses Excel should know!