How to copy "Ignore Error" all through?

[dindigul]

Hello
I have a formula wherein the result is ok, but gets flagged "missing
adjacent cells". I select the "Ignore this error" but how to copy this
across all cells? Or do I have to do it on every cell? Thanks

 

[Dave Peterson]

Select that whole range--make the active cell one of the cells with that error.

Then click on the flag and choose "Ignore Error".

 

[Gord Dibben]

Better yet

Go into Tools>Options>Error checking and turn it off.

That thing annoys me too much, along with paste options and insert options.


Gord Dibben MS Excel MVP