formula error triangles

  • Thread starter Thread starter Les P
  • Start date Start date
L

Les P

Could anybody tell me how to get rid of, or edit, those
annoying error triangles in excel xp. It picks up errors
that aren't, such as calculating a mean for a range and
omitting an ajoining column that you don't want included
anyway gets reported as an error with black triangles in
every cell of that column.

Many thanks
 
Tools>Options>Error Checking Tab>Rules

Uncheck which ever you don't want. Personally, I have them
all unchecked!

Biff
 
Hi
Chech for options in Tools, Options and "Error tracking" tab (please note I
have a French version of Excel so this option may vary (this may be a bad
translation)

HTH
Cordially
Pascal
 
Back
Top