View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default Quick way to "Shrink to Fit"

inthestands -

Select the column or multiple columns, and double-click any column separator
(above row 1) except the one on the far left.

- Mike

http://www.MikeMiddleton.com



"inthestands" wrote in message
...
I often need to shrink columns. Is there a faster way to get to "shrink to
fit" rather than to go into CTRL-1, alignment, shrink to fit? I am using
2007

Thanks in advance,
inthestands