I have heard that it is possible to get Excel to auto size columns to their contents with short cut keys Ctrl + ????. In Excel 2007.