In this lesson you will learn how to turn off green triangles which sometimes shows in the left corner of cell. It will make your spreadsheet more professional and save a lot of your time.
About green triangles
This is the possibility of an error in a cell. But what if they show and you are sure than 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 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 eg. Formulas referring to empty cells.