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.
Further reading: How to prevent closing Excel? How To Send Email From Excel? How to Get Data from another Sheet?