In this lesson, you will learn how to turn off green triangles, which sometimes show up in the left corner of a cell. It will make your spreadsheet more professional and save you a lot of time.
About green triangles
There is the possibility of an error in a cell. But what if they show and you are sure that everything is OK? You should remove these green triangles.
How to remove green triangles?
This is a sample report. It isn't professional because of these triangles.
To remove green triangles from your spreadsheet, go to Ribbon. Click File > Options.
Next, select Formulas in the left sidebar.
To turn green triangles off, untick the checkbox Enable background error checking.
Green triangles disappeared from your report.
TIP: How to disable checking rules in Excel
You don't have to disable Error checking at all. You can also disable some checking rules, e.g., Formulas referring to empty cells.