A
A
Andrey Filimonov2017-03-20 13:17:11
Google Sheets
Andrey Filimonov, 2017-03-20 13:17:11

How to set up automatic insertion of a formula in an inserted cell in Google Sheets?

Hello
There is column B in the Google Spreadsheet file, it has 10 rows with names, and there is column D, the composition of which, according to the formula, depends on the cells of column B, for example, in cell D5 the formula is: "=B5", in D6 the formula is: "=B6" etc. So if I insert a row with data in the middle of the range of column B, then the resulting cell in column D remains empty. How can I make it automatically take the formula of neighboring cells?
I made an example.
I met solutions for Excel, but there are no such menu items in Google spreadsheets.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey Filimonov, 2017-03-21
@fil_and

Help on google forum

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question