How to link existing sheet and google form?

Question

Google Sheets

Hello.
Created a sheet, edited all the fields as needed. Then I made a form, but the data is transferred to a new sheet.
How can I make sure that they are transferred to the cells I need, in the same sheet? To not create a new one.

Answer 1

A good and disturbing question. Short answer: "No way."
This cannot be done, because the primary source is the Form, instead of the Table. In your case, just get the data into a new sheet, and copy the formatting with the tool designated as a roller.

Answer 2

The form inserts a new line, how to stretch the formula into it automatically?