How To Remove Green Triangles From Cells In Excel
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.