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.
Post a Comment