Excel AutoComplete and AutoFill keyboard shortcut

Question

Does any one have a keyboard shortcut for excel that performs AutoFill and AutoComplete at the same time, as an alternative to the mouse i.e : selection ( 1 2 3 ) + doubleclick (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

In order, press and release Alt, E,I,S, to bring up the Series input. Press Enter to accept the defaults.

By Default, Linear option is selected, that's for numeric values! For auto-filling months or days, select Autofill option and then ENTER.

Answer 2

Use Ctlr+Down/Right key to select the cells you want to fill and press Ctrl+D (to fill down) or Ctrl+R (to fill right). Read more of this Autofill Techniqes here.

Answer 3

If the cell that you want to copy contains a formula, then my solution is to make this cell active, and select the region where I want to copy the formula to, using Shift + Down Arrow or Ctrl + Shift + End, or sg like this. So the white cell of the selected area will be the cell I want to copy. Then pressing F2, and then Ctrl + Enter will make the copy.

If you want to autocomplete the area with numbers, first select the area, and then press Alt, and then the letters to reach Autocomplete, and in there the Autocomplete Series (or sg like this, my Office is Hungarian). The default settings in the window should be good, so you only need to press Enter.

Answer 4

Selection + Double click on the bottom right hand, invokes the default values in the Fill Series dialog (Menu: Home -> Fill -> Series + Enter).

You can easily invoke the above without any mouse interaction using this shortcut:Alt + H + F + I + S + Enter