ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to get rid of green triangles from top-left corner of cells? (https://www.excelbanter.com/excel-discussion-misc-queries/71376-how-get-rid-green-triangles-top-left-corner-cells.html)

amin3570

How to get rid of green triangles from top-left corner of cells?
 
I understand these cells represent that formulas across the cells are not
consistent. I already know that, and these flags are only visually annoying.

Chip Pearson

How to get rid of green triangles from top-left corner of cells?
 
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" wrote in message
...
I understand these cells represent that formulas across the
cells are not
consistent. I already know that, and these flags are only
visually annoying.




Biff

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

Goto ToolsOptionsError checking

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

Biff

"amin3570" wrote in message
...
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 times are GMT +1. The time now is 10:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com