Shortcut Key For Column Autofit

  • Thread starter Thread starter Mahesh Kumar K Hegde
  • Start date Start date
M

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
 
Double-click on the right-hand border of the column header

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
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
 
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
 
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.
 
Back
Top