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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

spamlet - 18 Jul 2007 13:19 GMT

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

Reply to this Message

Brian Withun - 19 Jul 2007 14:40 GMT

> 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
[quoted text clipped - 4 lines]
>
> 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

Reply to this Message

spamlet - 20 Jul 2007 13:42 GMT

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

>> Allowing space to add further rows in a spreadsheet gives me a whole row
>> of
[quoted text clipped - 18 lines]
>
> Brian Herbert Withun

Reply to this Message