Wednesday, April 16, 2008

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.

2 comments:

Month/Day said...

well, this didn't work as well as I thought it did ... still better than clickin on the header a bunch of times with a big table though :)

Month/Day said...

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