View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
jfg jfg is offline
external usenet poster
 
Posts: 44
Default Automatically adjusting columns

Thanks, Dave.

"Dave Peterson" wrote:

Select all 11 columns first. Then they'all all react to that double click.

And you could throw caution to the wind and select all the cells and adjust all
of the non-empty columns at once!

jfg wrote:

I have Excel 2003.

I have a worksheet with 11 columns. I need to adjust the column width of
each column so that all data will be shown. I know that I can do this
adjustment by double clicking on each column's border, but that means 11
double clicks; I would like to adjust all of the columns with a single
action. Is this possible?

Thank you.


--

Dave Peterson