How To Remove Green Triangle In Excel

This tutorial volition demonstrate how to get rid of the green triangle in Excel.

greentriangle intro

If the data independent in a cell has an error equally far as Excel is concerned, and groundwork mistake checking is switched on, then a pocket-sized dark-green triangle will be shown in the left hand top corner of a cell. If you were to click in the cell, a drop downwardly list of solutions to the error will be offered. On some occasions, you may non want to amend the data in your prison cell, but you may desire to hide the green triangle, thus ignoring the mistake.

Switch off Background Error Checking

To stop the green triangle error from showing, you lot can switch off the background fault checking in Excel.

In theRibbon, selectFile >Options > Formulas > Error Checking.

greentriangle disable error checking

Remove the tick from the "Enable background error checking choice", and then click OK.

greentriangle removed

NOTE: This will remove groundwork error checking for the active workbook every bit well any workbooks opened in the time to come.

Amending Error Checking Rules

Instead of turning off Background fault checking completely, we tin switch off private rules that are by default switched on in Excel. For example, in the data above, the numbers are formatted as text and therefore cannot be used in calculation formulas. The green triangle volition permit us know this, and provide a drop down list of solutions. We can switch off this specific error check.

In theRibbon, selectFile >Options > Formulas > Error Checking.

greentriangle-disable number text error

In the Fault checking rules department, remove the check mark from "Numbers formatted as text or preceded by an apostrophe" to terminate Excel from checking for this error, and then click OK.

Ignore Error

Normally you would want to continue the background mistake checking switched on every bit it is very useful in showing u.s. if nosotros take an error in the data or, more importantly, in a formula.

To remove the light-green triangles from cells where you are enlightened of the error, but do non want to see the triangle, select the cells and so click on the piddling yellow assertion mark icon.

greentriangle error drop down

Click Ignore Error to remove the green triangles, or, if you want to solve the fault, click on "Convert to Number" – this will then enable you to use the numbers stored as text in formula calculations.

Solving the Fault with the Drop Downwards List

If you mistake is for a unlike reason, for example a Divide by Zippo formula error, then a different driblet downwardly list volition be shown.

greentriangle error div0 drop-down

Y'all can too ignore the error, or you you lot can click "Show Calculation Steps" to resolve the error. If you click "Edit in Formula Bar", Excel will put the formula into Editing fashion and identify your mouse pointer in the formula bar in order for you to improve the formula.

greentriangle edit in formula bar

Some other reason for the mistake could exist an inconsistent formula. This occurs when the formula in the cell is different to the formula that is in the cell in a higher place. If this is the case, a dissimilar driblet down list volition appear:

greentriangle inconsistent formula

To solve this problem and remove the greenish triangle, we tin click on the "Copy Formula from Above" option, or, if nosotros do non desire to amend the formula, we tin can once again click on Ignore Fault.

Common Errors in Excel

A few more mutual Excel errors will cause the dark-green triangle to bear witness in the Excel canvass – all of which can be removed using the "Ignore Error" option, or can exist solved using Excel'due south error checking options.

#REF – this error normally occurs when a formula is referring to a range that is cannot find – or if rows/columns have been removed.

greentriangle ref

Resting your mouse on the exclamation mark icon volition show y'all the reason for error, while clicking on the drop down will show y'all a dropdown listing of possible solutions to mistake.

greentriangle ref dropdown

#VALUE – this error normally occurs when you are trying to include a prison cell that has text in it, in a calculation.

Formula Omits adjacent cells – this error commonly occurs when you lot accept a function similar the sum function and are not including all the possible cells in the calculation.

greentriangle omit adjacent cells