Shortcut Key For Column Autofit

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

Hello,

The only shortcut possible for this action is ALT oca.
Not the best shortcut but it will save some time.

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Mahesh Kumar K Hegde" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

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
"Niek Otten" <[email protected]> wrote in message
news:#[email protected]...
> Double-click on the right-hand border of the column header
>
> --
>
> Kind Regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "Mahesh Kumar K Hegde" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> >
>
>

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

On Fri, 7 Jan 2005 18:32:03 +0530, "Mahesh Kumar K Hegde"
<[email protected]> wrote:

>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
>"Niek Otten" <[email protected]> wrote in message
>news:#[email protected]...
>> Double-click on the right-hand border of the column header
>>
>> --
>>
>> Kind Regards,
>>
>> Niek Otten
>>
>> Microsoft MVP - Excel
>>
>> "Mahesh Kumar K Hegde" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>> >
>> >
>>
>>
>

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.