Tags: across, cells, consistent, corner, excel, flags, formulas, green, microsoft, msdn, represent, rid, software, top-left, triangles, visually

How to get rid of green triangles from top-left corner of cells?

On Microsoft » Microsoft Excel

1,195 words with 2 Comments; publish: Thu, 22 May 2008 18:59:00 GMT; (306171.88, « »)

I understand these cells represent that formulas across the cells are not

consistent. I already know that, and these flags are only visually annoying.

All Comments

Leave a comment...

  • 2 Comments
    • Go to the Tools menu, choose Options then the Error Checking tab.

      There, uncheck the errors you don't want flagged.

      Cordially,

      Chip Pearson

      Microsoft MVP - Excel

      Pearson Software Consulting, LLC

      www.cpearson.com

      "amin3570" <amin3570.excel.questionfor.info.discussions.microsoft.com> wrote in message

      news:98474B12-7289-4B76-AFD7-DE5CCDF194C6.excel.questionfor.info.microsoft.com...

      >I understand these cells represent that formulas across the

      >cells are not

      > consistent. I already know that, and these flags are only

      > visually annoying.

      #1; Thu, 22 May 2008 19:00:00 GMT
    • Hi!

      Goto Tools>Options>Error checking

      Under Rules, uncheck all that you don't want to be "bothered" with. I have

      them ALL unchecked.

      Biff

      "amin3570" <amin3570.excel.questionfor.info.discussions.microsoft.com> wrote in message

      news:98474B12-7289-4B76-AFD7-DE5CCDF194C6.excel.questionfor.info.microsoft.com...

      >I understand these cells represent that formulas across the cells are not

      > consistent. I already know that, and these flags are only visually

      > annoying.

      #2; Thu, 22 May 2008 19:01:00 GMT