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).