inserting new lines automaticaly copy the formula above or below
for regular users it is really boring have to copy the formula each time you add a new line... (and yes, if they need a new line you will just insert a new line)
simple formulas as: D4+B5-C5 as the formula for the cell D5
if I add a new line the excel should ask me like formating, if I want to copy the formula from above or bellow
found that the next day! they are really usefull
Kenneth Barber commented
You can avoid this issue if you use tables (go to the Insert tab and then Table). If you insert a row in the middle of a table, the formulas will automatically fill in the gap. Also, you get banded rows and easy-to-read formulas. Tables are good all around.