Excel AutoComplete and AutoFill keyboard shortcut

Question

Is there a keyboard shortcut for Excel that, instead of using the mouse, conducts AutoFill and AutoComplete simultaneously? The shortcut is selection (1 2 3) + double-click (bottom right-hand side):

+--- +-------+
|Rank|  A    |
+--- +-------+
| 1  | a     |
| 2  | b     |
| 3  | c     |
|    | d     |
|    | e     |
|    | f     |
|    | g     |
+--- +-------+

I know a keyboard alternative: ALT+E+ENTER+I+S+F+ENTER but this does not do the whole job (auto-complete as the mouse-double-click).

Answer 1

Alt+E+I+S then press ENTER. By Default, the Linear option is selected, that's for numeric values! For auto-filling months or days, select the Autofill option and then ENTER.