Numbers Formula Not Updating to Include Added Rows

Hi M4020,

See if this works for you.

E2 is an entered value.

Formula in E3: E2−C3+D3 and fill down.

Click on any cell in the last row and press the return key. The formula is carried down.

Enter details in the new bottom row:

Woo hoo! The formula is indeed carried down 😊.

Regards,

Ian.

M4020 wrote:

The problem develops when I add (or delete) a row. The formula does not update and adjust to the new row in the column... Or is there no easy way to to do it?

You might consider the "expanding range" technique used in the attached Checking Register (Dropbox download) adapted from a template included with an old version of Numbers.

SG

It should copy down to the new row automatically if the same formula is being used in the cells above (other than the cell references changing to fit each row).

Your problem description sounds simple enough but can you post a screenshot that shows your table and your formula? I don't know what you are missing or if it is a bug or glitch with this particular table/document. Have you tried the same in a new document, just as a test?

Are you adding/deleting rows in the middle of the table, not at the bottom? Deleting a row often deletes cells that were being used in a formula, resulting in reference errors and error triangles. Adding a row in the middle can disrupt the "pattern" of the formulas in the column, as you noticed.

Any method of adding a row at the bottom of the table should work properly. Hitting Enter, dragging down on the bar below the row numbers, using Insert, etc. They should all work the same.