Hello, I may be able to help you. What version of Excel are you using? I'm using 2007, but 2007 or anything below will work. Also, this will, most likely, require the use of some VB script (which means you'll have to trust the excel file to allow the VB script to run). I'll also need to know the range of cells over which you want to auto resize/widen the cells as you enter text (actually, it won't resize until you type the text and hit enter or move to the next cell). And I'll need the excel file, which you can provide by attaching to this chat window as an image (it's a generic attachment process so it works for any type of file less than 5MB). Otherwise, wikisend and mediafire are two free sites you can use to get me the excel file to work on. Hopefully you'll find this a good start towards helping you with your question.
I may not be online when you respond, but when I see that you have responded I will check back to help you.