Share via

extend excel formula automatically as rows are added

Anonymous
2023-12-13T22:14:55+00:00

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?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-14T23:20:36+00:00

    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.

    6 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-12-14T00:25:55+00:00

    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

    2 people found this answer helpful.
    0 comments
  3. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2023-12-13T23:59:15+00:00

    Hi,

    Convert the source data range into a Table.

    0 comments