Reset error checking

Occasional Visitor

Have run error checking and selected ignore error or copy formula from above.  I would like to clear those settings so that running error checking again will find all of the errors.

1 Reply


There are several ways to hide or unhide error values and error indicators in cells.

Hide or unhide error values and error indicators in cells

If a cell contains a formula that results in an error, a triangle (an error indicator) appears in the top-left corner of the cell. You can prevent these indicators from being displayed by using the following procedure.


Cell with a formula problem

  1. In Excel 2016, Excel 2013, and Excel 2010: Click File > Options >Formulas.


    > Excel Options > Formulas

  2. Under Error Checking, clear or Check the Enable background error checking check box.


Hope I could help you with these information / links.



I know I don't know anything (Socrates)