Hide Error Values and Error Indicators in Cells

To hide error values (like #DIV/0!, #N/A, #VALUE!) and the green error indicators in Excel cells, use the methods below:

✅ 1. Hide Error Values in Cells

➤ Option A: Use IFERROR() Function

Wrap your formula to catch and hide errors.

=IFERROR(A1/B1, "")

• If A1/B1 causes an error (e.g., divide by zero), it will display blank instead.
• You can also show a custom message:

  =IFERROR(A1/B1, "Invalid")
  

➤ Option B: Use IF(ISERROR()) (for older Excel)

=IF(ISERROR(A1/B1), "", A1/B1)

✅ 2. Hide Green Error Indicators (Small Triangles)

Those indicators appear when Excel thinks a formula might be incorrect (e.g., number stored as text, or inconsistent formulas).

➤ Steps:

1. Select the affected cells or the entire sheet.
2. Go to File > Options > Formulas.
3. Under Error Checking, uncheck:
   • “Enable background error checking” (disables all indicators)
     OR
   • Leave it checked, and uncheck specific rules under “Error checking rules” (e.g., “Numbers stored as text”).

✅ 3. Conditional Formatting to Hide Errors (Optional)

Use this if you want to gray out or hide error cells visually:

Steps:

1. Select the range.
2. Go to Home > Conditional Formatting > New Rule.
3. Choose “Use a formula to determine which cells to format”.
4. Enter this formula:

   =ISERROR(A1)
   

5. Click Format, and set the font color to match the background (e.g., white on white) or use a light fill.

🧠 Example: Combine All

To divide A1 by B1 but:

• Show blank if error
• Avoid green indicators

=IFERROR(A1/B1, "")

Then turn off error checking for that cell type in Options.