How to turn off error checking green triangles in Excel

Forum to talk about all the latest technologies - ins and outs!!
Post Reply
Admin
Site Admin
Posts: 312
Joined: Tue Sep 25, 2007 12:41 pm

How to turn off error checking green triangles in Excel

Post by Admin » Sun Mar 26, 2017 12:31 pm

Sometimes you have error checking, otherwise known as, green triangles in the upper-left corner of your cells in Excelsheet possibly suggesting errors in the formula in those cells.

Sometimes you get it if you type numbers into cells that were previously formatted as text.

Sometimes you get it if you import data into Excel from another source.

Sometimes you get it even you have calculated everything perfect :-)


Image



So how to turn these tiny green triangles off?

In Excel 2010 and later versions go to the File tab on the ribbon > click on Options

In Excel 2007 click the Office button > then click on Excel Options


Excel Options window opens


Click on Formulas category in the left sidebar

From under Error Checking uncheck Enable background error checking

Click OK.


Image


The green triangles should disappear by now.


Image


Have fun :-)






*Recommended:


Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.


For comments of suggestions, please contact us: info@shamskm.com

Troy Collins
Posts: 1
Joined: Wed Jul 15, 2020 10:10 am

Re: How to turn off error checking green triangles in Excel

Post by Troy Collins » Mon Jul 20, 2020 2:04 pm

I was really upset with these triangles. Whenever I wrote some data the green triangle was shown and I was irritated. Now I will be able to read college-paper.org reviews and get rid of it. Thank you for sharing this. It was really helpful.

Post Reply