Issue With Formula Not Automatically Adding Itself After "INSERT" or row or column

Hi everyone,

I am having an issue with my spreadsheet and cant figure out how to make this work. I currently have formulas in columns "K" and "L" going from row 2 to 32.

When I try to "insert" a row it seems that both columns "K" and "L" for that inserted row are empty. How would I go about making it so their respective formulas are automatically entered with the right ones when doing so? Thank you!

A weird way of going about this:

I add a blank line in row 36. I then made K1:L36 a table.

When Entering new data click on row 36 and then insert a new row. This will create a new row 36 with all formatting and formulas in tact, and the blank row will now be row 37. Pretty much make sure there is always a blannk row.

To remove the blue from the Table just click on the table and go to Table Tools then Design at the top ribbon. UNSELECT Banded Rows.

Originally Posted by dosydos

A weird way of going about this:

I add a blank line in row 36. I then made K1:L36 a table.

When Entering new data click on row 36 and then insert a new row. This will create a new row 36 with all formatting and formulas in tact, and the blank row will now be row 37. Pretty much make sure there is always a blannk row.

To remove the blue from the Table just click on the table and go to Table Tools then Design at the top ribbon. UNSELECT Banded Rows.

Hey dosydos,

That's a great idea that I could try but my dilemma is that I will need to enter new rows pretty much anywhere between row 2 and 32 at some points. So therefore only adding at the bottom would not work for me unfortunately.

My solution will still work. for example, select row 15 and then insert a new row. the new row will have the formulas in K and L already. The whole blank row at the bottom is necessary only if you are adding rows to the bottom.

Originally Posted by dosydos

My solution will still work. for example, select row 15 and then insert a new row. the new row will have the formulas in K and L already. The whole blank row at the bottom is necessary only if you are adding rows to the bottom.

Ahhh, I was looking at another row. Looks good to go now! Thank you!