Keyboard Shortcut

[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?

Many thanks

 

[Héctor Miguel]

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.

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Héctor Miguel]

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 __