Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

Debbie has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Excel 2003

Is there a way I can turn off the inconsistent formula green triangle thing? It is useful sometimes but often it's just warning me about something and after the 10th time it appears I'd like it to go away!

RE: Excel 2003

Hello Debbie

Thank you for your question and welcome to the forum.

If you go into Tools - Options, and select the Error Checking tab, under Rules, uncheck all the rules relating to formulas:

Inconsistent formula in region
Formula omits cells in adjacent region
Unlocked cells containing formulae
Formulas referring to empty cells

This should stop the majority of green triangles appearing.

Kind regards
Amanda

Excel tip:

Paste a web address into the hyperlink address field

If you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.