alright, there is actually a way to do this built into excel! good, it is as it should be! format > column > autofit selection
ever wondered how to adjust all columns to the smallest width necessary to fit all data, all at once? i just figured this one out, but wish i knew before:
1. hit select all twice (i.e. ctrl + a, ctrl + a)
2. right click on the header area of your table, select ‘column width’
3. set your column width to 1
voila … your columns are all now the proper width.