There seems to be a keyboard shortcut for almost everything in Excel. Is
there some key combination that can be used for Autofill instead of using
AutoFill with the mouse?

Many thanks
--
Kind regards

Ann Shaw

hi, Annie !

> There seems to be a keyboard shortcut for almost everything in Excel.
> Is there some key combination that can be used for Autofill instead of using AutoFill with the mouse?

I guess there is no such built-in short-cut but...
you can create a macro and assign a convenient keyboard combination ?

macro execution shall be after select your fill-range and should look like this one:

Sub AutoFill_ShortCut()
SendKeys "~"
Application.Dialogs(xlDialogDataSeries).Show , 4
End Sub

hth,
hector.

For certain operations like filling a formula down use CTRL + d


Gord Dibben MS Excel MVP

On Sat, 6 Feb 2010 11:50:01 -0800, Annie <(E-Mail Removed)>
wrote:

>There seems to be a keyboard shortcut for almost everything in Excel. Is
>there some key combination that can be used for Autofill instead of using
>AutoFill with the mouse?
>
>Many thanks

hi (again) Annie !

and... if you don't like/trust/... the sendkeys method...
change both lines in the sub for this single one:

executeexcel4macro "data.series(,4)"

hth,
hector.

__ previous __
>> There seems to be a keyboard shortcut for almost everything in Excel.
>> Is there some key combination that can be used for Autofill instead of using AutoFill with the mouse?
>
> I guess there is no such built-in short-cut but...
> you can create a macro and assign a convenient keyboard combination ?
>
> macro execution shall be after select your fill-range and should look like this one:
>
> Sub AutoFill_ShortCut()
> SendKeys "~"
> Application.Dialogs(xlDialogDataSeries).Show , 4
> End Sub