Jump to content
Sign in to follow this  
Mike MacGregor

Tip: Getting Rid of the Green Triangles

Recommended Posts

I kind of forget some of these things until people ask about them, or in this case since I've started (begrudgingly) using Excel 2007 more, I noticed the green triangle menace, also known as Excel's potential error checking system.

 

When you open up your copy of the Compiler or Draft Buddy, have you noticed your cheatsheet filled with little green triangles? Excel puts those there because it thinks maybe, possibly the formulas in those cells have an error in them. They don't. This is one of those features where Excel is trying to be helpful to basic users, but in turn, annoy more advanced users like us :music_guitarred:

 

You don't have to get rid of these things if you don't want to. You can look right past them, and they won't print if/when you print your cheatsheets, but I think they just look bad on the screen and I prefer to get rid of them. So how do you do that? Check the new screencast, right here:

 

http://www.fftoday.com/compiler/screencast...ngles/index.htm

Share this post


Link to post
Share on other sites

For Excel 2010...

 

Go to Formulas > Error Checking > Options > and uncheck the box "Enable background error checking". Bye-bye annoying green triangles.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×