How to correctly set up the formula in each line in Google Docs (the same Exel)?

Question

Google

Such a problem
read different sources, if the formula is in each line, then everyone manually prescribes their variables for each copy of the formula (in line 2 D2, in line 105 D105), but this is dreary strong.
I remember in honey, in computer science, they were doing this nonsense (I still thought - why can I use this nonsense in my life?), And there was definitely something that made such formulas automatically work and automatically substitute values ​​from the right cells in line.
How to do it in Google Docs?

Answer 1

Select the cell with the formula, press "Ctrl" + "C", then select the desired cell and press "Ctrl" + "V".

Answer 2

In general, this is how the formula should look like if you need to add cell E to cell A in each row and multiply by cell C:
=(E:E+A:A)*C:C