Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to turn off error checking green triangles in Excel

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 271

PostPosted: Sun Mar 26, 2017 12:31 pm    Post subject: How to turn off error checking green triangles in Excel Reply with quote

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 Smile






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.





The green triangles should disappear by now.





Have fun Smile






*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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group