Insert row including formula

[Quimera]

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

 

[Sirirat]

Hi Rose,

You can select those range of cells and choose Insert | Table from the menu.
Once the range becomes a Table, the formula will be automatically updated.

Let me know if this help.

Sirirat

 

[Quimera]

Hi Sirirat,

Sorry, I cannot find the option to "Insert|Table" on the menu. Where is
it hiding?

Rose

 

[Sirirat]

You can use shortcut keys
Ctrl+t
or
Ctrl+ l (L not i)