Feedback by UserVoice

# 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

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Taina shared this idea  ·   ·  Admin →

(thinking…)
Signed in as (Sign out)
Submitting...
• Kenneth Barber commented  ·   ·  Flag as inappropriate

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.