How to stretch cells for a certain number of lines without a mouse?

Question

excel

without mouse and dragging how to add a formula to e.g. drag cells every time + 199 cells
there is data
12 row) group 1 (199 cells)
212 row) group 2 (199 cells)
etc..
how to add data further with a formula like this
group 3*199
to fill cells quickly and not calculate the line, how many lines will be under 199 pieces

Answer 1

1 - Select the cell with the formula
2 - Drag the selection to the desired size (arrow keys while pressing shift)
3 - You get a selected area with the active cell where the formula
is 4 - Press F2 - edit mode (the cursor will appear in the cell with the formula)
5 - Press Ctrl + Enter and your Formula is copied over the entire selection.

Answer 2

Macro below:

Sub AutoFillRange()
    ActiveCell.AutoFill Destination:=Range(ActiveCell, Cells(ActiveCell.Row + 187, ActiveCell.Column)), Type:=xlFillDefault
End Sub

stretches the formula down by (199 - 12) cells.
To use it, you need to put the cursor on the cell and run the macro for execution.
In the future, you can install and run the macro with a key combination.
You can also automate the stretching of the formula in the entire column of the table with one button, but first you need to look at the structure of the table.

Answer 3

Enter the formula to be dragged down.
Place the cursor on the lower border of the range where you want to stretch the formula.
Press Ctrl+Shift+Up to select everything from the selected cell up to and including the cell with the formula.
Or just select the desired range using Shift and cursor keys.
Press Ctrl+D. This will fill in the formula (or value if it's not a formula) from the top cell in all the selected cells.