I have a simple spreadsheet that automatically updates the bank balance
when debits/credits are entered on a new row.

Row D = Debits Row E = Credits Row F = Balance

=IF(Debits+Credits 0,F308-Debits+Credits," ")

However, when I insert a row, the formula above does not repeat
automatically. I have to drag it down into the blank column F cell to
enable it.

For some unfathomable reason the following Googled solution does not
seem to work for me: either:

"Just select the complete row, above which you want to insert a row,
then
click copy and then insert the copied row above it. The new row would be
like
the one copied and the formulas will also be copied and updated to new
values."

I have tried using the insert options as well. Same result. No formula
in column F.

Thanks for your help.

Rose