I know it’s possible to insert a blank row before the current row using Insert → Rows. Is there a way to insert a blank row after the current row, so that all the subsequent rows are moved down 1 (but the current row remains in place)?
Use case: I have a SUM total at the bottom of my table and if I go to insert a new data row just before the total line, the range to the SUM function is not updated, whereas if I insert a new data row anywhere else the range is updated as I expect it to be.