How to hide error indicators in Excel 2007 cells

I find it annoying sometimes when I enter a correct formula in a cell and Excel gives me an error like “Inconsistent Formula” or “Formula Omits Adjacent Cells”.

Fortunately you can hide these error indicators through Excel Options.

1. Click the Microsoft Office button.
2. Click Excel Options.
3. In the left pane of Excel Options click Formulas.
4. In the  Error Checking section, clear the Enable background error checking check box.
5. Click OK.

Related posts:

1. Average cells based on multiple criteria in Excel 2007
2. Average values based on a given criteria in Excel 2007
3. Sum cells with multiple criteria in Excel 2007
4. Count cells with multiple criteria in Excel 2007
5. Find cells that meet specific criteria in Excel 2007