How to copy "Ignore Error" all through?

D

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
 
D

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".
 
G

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
 
Top