alright, there is actually a way to do this built into excel! good, it is as it should be! format > column > autofit selection

obsolete idea:
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.


  1. ok, this is what you need to do … all the same as before, but while the table is still highlighted double click a divider in the header … you maybe be able to do this without any “column width” adjustement at all

Leave Comment