Keyboard Shortcut

External Since: Nov 9, 2008 Posts: 1

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

External Since: Jan 23, 2010 Posts: 3

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.