Insert row including formula
 

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

Insert row including formula
 

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" wrote:

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

Insert row including formula
 

Hi Sirirat,

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

Rose



"Sirirat" wrote in message
...
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" wrote:

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

Insert row including formula
 

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

"Quimera" wrote:

Hi Sirirat,

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

Rose



"Sirirat" wrote in message
...
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" wrote:

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