Formula omits adjacent cells: ignore a whole row at once?

[Guest]

Allowing space to add further rows in a spreadsheet gives me a whole row of
totals where the formula is tagged as 'formula omits adjacent cells'. How
can I get the thing to ignore the lot at once rather than having to open all
the drop down dialogues one at a time?

Cheers,

S

 

[Brian Withun]

Allowing space to add further rows in a spreadsheet gives me a whole row of
totals where the formula is tagged as 'formula omits adjacent cells'. How
can I get the thing to ignore the lot at once rather than having to open all
the drop down dialogues one at a time?

Cheers,

S

Well, if you just want Excel to use your formulas as-is rather than
detecting 'formula omits adjacent cells,' then you can disable "List
Extending" ...

Go to Tools > Options and view the "Edit" Tab. Once there, turn off
the option to "Extend list formats and formulas"

This ought to remove all of your formula tags immediately.

Brian Herbert Withun

 

[Guest]

Thanks Brian,

But I don't really want to loose the tips altogether, for occasions when I
have genuinely made a mistake. I just wanted to 'ignore' a whole row of
these tags at once rather than one at a time, though it looks as if this is
what I will have to do...

Cheers,

S