Shortcut Key For Column Autofit

[Mahesh Kumar K Hegde]

Dear Friends ,

Pls Tell me what is the shortcut key for autofit coloumn in Excel 2002 .
like, for format cell we can press Ctr+1. L, is there any shortcut for
dooing the autofit column..Pls..

Regards,
Mahesh

 

[Niek Otten]

Double-click on the right-hand border of the column header

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Mahesh Kumar K Hegde]

Hi Niek Otten,

Thanks for reply But Its not the option i am looking at
i want to know , is there any option by pressing ctr+1 or alt+ctr+1
like..keys . For example for raw hide we can use Ctr+9.for unhide the raw we
can use Ctr+Shift+9




Thanks
regards,
Mahesh

 

[Gord Dibben]

Mabesh

The best I can come up with is ALT + o,r,a

I don't believe there is anything else.


Gord Dibben Excel MVP

 

[Jack]

This can be accomplished through VBA. I used to have an icon on my toolbar
that would autofit all the columns in the workbook but hey VBA is
complicated and I don't remember.

I tried looking through the book on how I did this but can't find it.
Basically you start a macro and change the VBA to select all the cells in
the worksheet and then apply autofit to all the columns. You then save the
macro and assign it to your toolbar or give it a hot key.