deleting error message

[Brian]

My spreadsheet contains approx. 500 rows and 50 columns.
The formulas result in a small green triangle(smart tab?)
which indicates "formula omits adjacent cells". I can
click on "ignore error" and the small green triangle will
disappear. I would like to remove all small green
triangles however it appears that I have to click on each
cell individually and click on "ignore error" in order to
do this. Is there a way to remove all triangles in the
worksheet at once?

 

[Myrna Larson]

Go to Tools/Options/Error checking and see if unchecking the box to "Enable
background error checking" will turn this off.

 

[NH]

go to tools>options>error checking.
and uncheck "Enable background..."