The problem: in my table, filled with rather complex cell formulas, I want to insert new lines. When inserted, the formula of the respective column should be automatically inserted. It currently works for some columns (In the screenshot green ) and doesn't for others (In the screenshot white). I do not know why it doesn't work for some columns. Screenshot: Rows 91 and 92 and are inserted here.
(unfortunately i cannot upload the screenshot, since it is my first post. but i hope you can imagine...)
*
How can I modify this table so that all columns automatically insert the right formula for each respective column? I.e. the formula that all existing cells of this column already contain?
*
My assumption: it doesn't work since it is a named table and when I created it I was initially asked whether the formulas for a column should be inserted in all cells of this column. Perhaps I didn't say yes for all columns consistently. Maybe the problem is related to this?
*
The table is already filled with many values and I want to continue using it. Any help is welcome how I can modify this existing table so that the new inserted rows automatically adapt the formula of the specific column.
Anybody knows how this could work?
Thanks a lot!
Matthias
Bookmarks