Suppressing All Error Indicators
When you're dealing with a worksheet that for whatever reason is riddled with error values and their attendant error indicators, you can get rid of the indicators in one fell swoop by following these simple steps:
- Choose Tools → Options.
- Select the Error Checking tab in the Options dialog box.
- Deselect the Enable Background Error Checking box and then click OK.
As soon as you close the Options dialog box, Excel temporarily removes all the error indicators from the entire worksheet. To restore them, all you have to do is open the Error Checking tab of the Options dialog box and then select the Enable Background Error Checking box again.
Suppressing the display of the error indicators has no effect on the display of error values in the worksheet. To do that, you either have to fix the problem or use one of the techniques in the following section for hiding their display.