CODEWITHSUNDEEP
excelkeyboard-shortcuts
DKK
DKK

Reputation: 1920

Excel AutoComplete and AutoFill keyboard shortcut

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

Upvotes: 3

Views: 55742

Answers (4)

user3828210
user3828210

Reputation: 21

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.

Upvotes: 2

Prakash G. R.
Prakash G. R.

Reputation: 4892

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

Upvotes: 0

Seekers Elite
Seekers Elite

Reputation: 11

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.

Upvotes: 1

Imre Greilich
Imre Greilich

Reputation: 3412

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.

Upvotes: 0

Related Questions