Keyboard Shortcut

  • Thread starter Thread starter Annie
  • Start date Start date
A

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
 
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?
Click to expand...

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
 
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 __
 
Back
Top