Have you ever noticed a green triangle appears on the upper left side of the Excel cell?
If you have ever been in such a situation, you must not have been able to do anything. Right?
Not a single operation can be performed in this situation because these little triangles show potential errors in the data present in a cell. Once this triangle appears while working on an Excel sheet, you can easily get to know about an error present in the data.
Potential reasons behind the existence of this little triangle could be data validation errors, invalid data types, or inconsistent formulas. To find the exact reason for this triangle, click on the cell with a triangle and click on the “Error Alert” option given in the Formulas tab. It will clearly inform you about the error cause.
So, how would you remove this unwanted triangle? In this post, you will get to know how to remove green triangles in Excel.
How to Avoid Green Triangles?
You definitely want to avoid these unwanted triangles even though these little triangles are useful. Let’s see how you can do it:
- Data Correction
Once you find out why these triangles are appearing, you can easily get rid of them. If the green triangles are because of an invalid data type, you need to make changes in the data type. On the other hand, if the reason is a formula error, you need to make corrections in the formula. Or else if the data validation error is the reason, try correcting the data according to the rules.
- Error Clearance
Once you have corrected all the errors in your data, you can now easily remove them by selecting the cells in which these triangles are present. Now, click on the “Clear Validation” tab from the “Data” tab.
How to Turn Off Background Error Checking Option?
If you don’t want the green triangles to appear while working, you can turn off background error checking in Excel. For this, you can follow the steps given below:
- Open the File tab and choose Options from the menu. Click on Formulas and then choose Error Checking.
- Uncheck the Enable background error checking option and then click OK.
Notice: This procedure can remove the background error-checking scheme for the worksheet you are working on.
Change the Value to Number
In this solution, you can follow the steps given below:
- Open the workbook in which errors are appearing.
- At the upper right side of a cell, you can easily see green triangles. Now, click on triangles and an exclamation mark will appear.
Click on this mark.
- Choose the Convert to Number option from the drop-down menu.
- When there are a few cells that appear with green triangles, this method works wonderfully. On the other hand, when your data has many cells containing triangles, you can try another method given here.
Multiple with a Number Value
Here is another solution to this query:
- Open the workbook that shows errors.
- Type 1 in any given cell.
- With CTRL + C, click on that cell and copy the value.
- Choose all the columns that contain green triangles.
- Open the Home tab from the menu.
- Click on the down arrow under the Paste option.
- Choose the Paste Special option from the drop-down menu.
- Click on the Multiply option given in the Paste Special window.
- Press OK.
All the green triangles will disappear from the screen.
That’s it!
Disable Error Checking Rule – Number Formatted as Text
By following this procedure, you can easily get to know how to remove green triangles in Excel. Let’s see how it happens:
- Open the Excel file in which green triangles are present.
- Click on the File menu.
- Select the More option and click on Options.
- Click on the Formulas option given in the Excel Options window.
- Uncheck the Number formatted as text or preceded by an apostrophe option given under the Error Checking Rules menu.
- Now, click on OK.
That’s it!
To Wrap Up:
This post clearly defines how you can easily remove green triangles in Excel while working. Your dataset could have potential errors that make triangles appear in the cell. By correcting those possible errors you can manage to remove these green triangles quickly. Try any of the above methods and enjoy your error-free sheet.
