Change the Excel settings to Hide Error Indicators
As you can see in the above example, whenever a cell contains an error, a triangle appears in the top-left corner. This is nothing but an error indicator. Follow the steps given below to hide these error indicators:
Step 1: Go to file tab and select options.
Step 2: A dialog box will appear. In this box, go to the formulas section and deselect the enable background checking box under the error checking section.
Step 3: Click ok.
This was to hide the error indicators, now onto error values.
Hide Error Values and Indicators in Cells in Excel
While working with formulas in spreadsheets, we might get error values. These error values are often shown in the cells as error indicators. Sometimes, they are helpful in resolving errors but other times when errors need not be corrected, these error values just make the spreadsheet look cluttered. In such a situation, it is better to hide these error indicators to not only make the spreadsheet look clean but also to prevent these errors from stopping other formulas to work correctly. Let us discuss the different ways in which we can do that but first let us look at the problem statement with an example.