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

@JT330i 

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.

 

NikolinoDE

I know I don't know anything (Socrates)