How to Ignore Error in Excel

Microsoft Excel is a powerful tool that allows users to enter and manipulate data in a variety of ways. However, as you enter data into Excel, the program is constantly scanning your spreadsheet for errors. If it encounters an error, Excel will put a green triangle in the upper left-hand corner of that cell.

Fortunately, ignoring these errors is easy to do. If you want to see the specific errors that Excel checks for, they’re all located in the file options dialog box on the formulas tab. The section that we’re interested in is in the lower half. Specifically, we’re going to look at any cells where numbers have been stored as text.

If you have several numbers that are stored as text and you get that green triangle in the upper left-hand corner of the cell, you can still ignore the errors. If the numbers are there for display purposes only and you’re not going to perform calculations with them, you don’t have to click on the trace error button and click convert to number, which solves the problem and corrects the error.

To ignore the errors, you just click the trace error button and then click ignore error. The green triangles will disappear, and you can continue working on your spreadsheet. Alternately, you could go back into the file options dialog box, select the formulas tab, and then disable/enable background arrow checking. That would do it, too.

If you ever need to bring the error messages back, you can click on reset ignored errors, and all of the arrows will once again be displayed. With these easy steps, you can quickly and easily ignore errors in Excel, allowing you to focus on the data and calculations that matter most.