Hide error values and error indicators

Excel for Office 365 for MacExcel 2019 for MacExcel 2016 for MacExcel for Mac 2011More...Less

If your formulas have errors that you anticipate and don't need to correct, you can improve the display of your results by hiding error values and error indicators in cells.

Formulas can return errors for many reasons. For example, Excel cannot divide by 0, and if you enter the formula =1/0, Excel returns #DIV/0. Error values include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. Cells with error indicators, which appear as triangles in the top-left corner of a cell, contain formula errors.

Tip: You can also hide precedent and dependent tracer arrows once you've identified the cell that is causing an error to appear. On the Formulas tab, in the Formula Auditing group, click Remove Arrows.

On the Display tab, select the Error values as check box, and then do one or more of the following:

To display

Do this

A value in place of error values

Type the value that you want to display instead of errors.

A blank cell in place of error values

Delete any characters in the box.

Tip: You can also hide precedent and dependent tracer arrows once you've identified the cell that is causing an error to appear. On the Formulas tab, in the Formula Auditing group, click Remove Arrows.