When you see a little green triangle at the top left of an Excel cell, it is giving you a warning message to say there may be some inconsistency in your formulas. If you have checked your formulas and know they are right, it is a little frustrating to still see the green triangles. To move them all at once from a cell range, select the range, then go to the dropdown by the exclamation mark that appear to the left of the first of the cells in your selection.
Click Ignore Error. The green triangles will disappear.
Find out more about our Excel training courses Sydney, Australia.