What to do if the input value in Excel is illegal

Solution to illegal input values ​​in Excel: First find the "Data Verification" button under the "Data" label; then click this option and click Next; finally, after setting up, continue to click the OK button. .

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Solution to illegal input value in excel:

1. First, take a look at the high-definition picture of the crime scene: When we want to enter in cell C1, Once you enter, you will see the above prompt.

2. After canceling, return to the spreadsheet page and select cell C1. At this time, some people may find that there is a small drop-down triangle symbol in the lower right corner of cell C1. , as shown in the figure, actually the problem lies here.

3. When we click the drop-down arrow, we will find that a content list pops up. At this time, we understand that cell C1 is restricted to only input the content in the list. .

4. At this time, you will find the "Data Verification" button under the "Data" label, click this option, and then continue to the next step.

#5. After setting, continue to click the OK button and return to the interface again. At this time, you can enter any content in cell C1.

The above is the detailed content of What to do if the input value in Excel is illegal. For more information, please follow other related articles on the PHP Chinese website!