How to Get Rid of the Annoying Excel Warning About Differences in Formulas
There is an idiot light in Excel that often times needs to be shut off if you want to keep your sanity and keep your spreadsheets looking sharp.
The evil little critter looks like a paint brush and shows up hovering slightly over the edge of a cell’s corner. It is supposed to tell you that the cell in question does not have the same formula as a cell next to it.
That is great if you have a massive spreadsheet of heavily repeating formulas.
However, when you have a spread sheet where the cells formulas are very different from cell to cell it gets in the way and becomes tedious to deal with, especially if you need to click into a cell obscured by this paint brush.
Plus, when it comes time to offer up your spreadsheet in a presentation or report, having a bunch of paint brushes in the document can infer to the people receiving your report that you have errors where none really exist. This is bad for conveying confidence in your numbers and results and I advise that you turn this little whiz bang off in your spread sheet before you send it out.
Of course, the people that receive the spreadsheet may have it on and there isn’t much you can do about that unless you put the spreadsheet into a pdf or something.
Here is how you can shut the paintbrush error / idiot light off in Excel!
Go to Tools in the menu, Select Options, then uncheck the box that says
Inconsistent formula in region
Then hit ok and click on a cell somewhere in the spreadsheet and it should be gone, until you reactivate it.
Hope that helps a little bit, its not curing mesothelioma or other types of cancer but might reduce your stress level a bit.
Page Popularity for Site: 31% [?]
; ?>/images/feedicon24.png)
Anyway to turn off warnings like “Negative or zero values cannot be plotted correctly on log charts. Only positive values can be interpreted on a logarithmic scale. To correct the problem, do on of the following:”??
Seriously, there should just be a right click option, “This is annoying me/Hide Warning” to get rid of annoying warnings.
[Reply]
absolutely the most annoying thing in Excel!!! I work a lot with massive spreadsheet log charts, often created by others and removing all zeroes and negatives is a real chore. I’m so annoyed by this “Negative or zero values cannot be plotted correctly on log charts” I’m about to write to Microsoft about it!!!
[Reply]