Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

There is the option Menu/Tools/Options/LIbreOffice calc/General - Expand references when new columns/rows are inserted.

With that activated when in the last row with data you can use "Insert row below" and the formula is adapted properly.

https://help.libreoffice.org/6.3/en-US/text/shared/optionen/01060300.html?DbPAR=SHARED#bm_id3151110