Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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

4 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Taina shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
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.

Feedback and Knowledge Base