How to use autocomplete feature in Excel using only keyboard?

Question

excel

Need to "extend" a list in Excel using only the keyboard. That is, if I have a row number 1, 2, 3..., then after autocomplete the row should continue. I know that you can select the required area using shift and arrows, but what to do next?

Answer 1

- if it's just a sequence of numbers, you can write a formula
- in English Excel Alt HF i S Enter (entered sequentially), then set autocomplete parameters in the dialog
If Excel is Russian, press and release Alt, and see which keys will lead you to the desired item, it's on the home tab on the right

Answer 2

You can do this:
Select cells with 1, 2, 3 and then empty to what we need to fill.
Press Alt and then with the Tab buttons or arrows we reach the Editing menu section and there "Fill". Press Enter, select "Progression", if necessary, select Arithmetic and press Enter again.
Ready.

Answer 3

Create an autocomplete macro and run it with a keyboard shortcut.
The macro will have one line. You can use the macro recorder to create a macro.