Eliminate Excel cells green small triangles

Source: Internet
Author: User

If you copy data from another place and paste it into Excel, it is likely that the upper-right corner of the cell will have a green triangle symbol.

The symbol indicates that Excel has a function to prevent the user from misoperation. The green triangle is used to indicate that the current cell and surrounding cells have formulas or formatting or errors. Excel cannot recognize data in this format, and it is very likely that you will not be able to produce the correct results when you use formulas to compute.

If you encounter this problem, you can use the following methods to resolve it.

First, the partial solution

Select the cell with the green triangle, which will appear next to a Warning Drop-down button, click the Drop-down button, select the item in the menu as you want to see the content, or simply ignore the error.

This method is a good way to quickly resolve a single cell or a column of data. However, if such cells are distributed throughout an Excel document, it can be cumbersome to operate.

Second, the global solution

EXCEL2003: Tools-> options-> error checking-> setting-> the "Allow background error checking" hook to be removed.

Excel2007: Office Button->excel option-> formula-> check error checking rule

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.