Reset error checking

[JT330i]

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.

[#2]

@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)