extend excel formula automatically as rows are added

Question

I have a pretty basic Excel worksheet to keep a running balance in a money account. In addition to a date column and a description column, I have a column for money in and a column for money out and column for a running balance. How do I automatically extend the running balance formula when I add a new row?

Answer 1

Hmmmm. Doesn't seems to work. I selected the three columns that contain the "in" and the "out" amounts as well as the running balance. Then I clicked on INSERT > TABLE which converted those three columns to a table. Then I added data into the row at the bottom of the existing information. In the running balance column I entered the formula to start with the last balance amount plus the amount in the "in" column minus the amount in the "out column. I got the new running balance figure and then added another new row of money in and tabbed across to the running balance. The formula did not automatically extend to this new row. I have to pull down the formula cell lower right handle to copy the formula to the new row.

Answer 2

Hi,

Convert the source data range into a Table.

Answer 3

Hello BOLOKE,

I'm Ibhadighi and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.

To automatically extend the running balance formula in Excel as new rows are added, use a table:

1. Convert to Table: Select your data range and convert it into a table. You can do this by going to the 'Insert' tab and clicking 'Table'.
2. Use Table Formulas: In your running balance column within the table, input your formula. Excel will automatically apply this formula to any new rows added to the table.

This way, whenever you add a new row to the table, the formula for the running balance will automatically be applied to that row.

I hope this helps

Best Regards, Ibhadighi