Formulas Mess Up on Insert Row


M

MJS

I'm not sure I'm posting this in the right place but here goes.

I'm using Excel 2007. Excel is "supposed" to default to copying formulas
into inserted rows by default (assuming previous rows have the same formula).
I've also ensured the option to Extend data range formats and formulas is
checked in [Windows Symbol]->Excel Options->Advanced.

My formulas are not being copied to the inserted row and one formula in the
row below where a relative reference to the row above is not adjusted
correctly (i.e. a simple "=A5" for row 6 on insert remains "=A5" rather than
adjusting to "=A6").

So two different problems but both occurring when I try to insert a row.

Any idea why this isn't working properly?

MJS
 
Ad

Advertisements

A

AdamV

I am not aware that Excel is supposed to put anything into an inserted row by
default.
Format will match the row above the insert point.
The only place formulas get created automatically is inside Table (or a 2003
List)

As for formulae not updating, I agree that if you insert a row above row 5,
a formula referencing A5 should now read A6 etc. (excluding functions like
Indirect, or VB modules)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top