How to cancel the limit if the input value in excel is illegal

php editor Youzi will introduce to you how to cancel the restriction of illegal input values ​​​​in Excel. When using an Excel spreadsheet, sometimes you may encounter situations where the input values ​​do not meet the requirements, resulting in limitation errors. The method of unblocking is simple and easy, which can help you easily deal with this problem and improve work efficiency. Next, we will introduce in detail the specific steps to cancel the illegal restriction of Excel input values, allowing you to easily deal with various situations.

First of all, let us take a closer look at the high-definition pictures of the crime scene. When we enter content in cell C1, just press the Enter key and 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. Note: Sometimes the drop-down triangle will not appear, but it does not affect our subsequent problem processing.

　

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. . as the picture shows.

　

4. Okay, continue to cancel the input content, and let’s solve the problem. Return to the excel editing interface and click the "Data" tab on the toolbar, as shown in the figure.

　

5. As shown in the picture, you will find the "Data Verification" button under the "Data" label, click this option, and then continue to the next step.

　

6. Select the "Data Verification" option in the pop-up selection box, as shown in the figure. Note: You can also specify the cell content here.

　

7. In the pop-up "Data Validation" dialog box, find "Allow" of "Verification Conditions", click the drop-down menu, and select the "Any Value" option, as shown in the figure shown.

　

8. 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. as the picture shows.

　

Through the above few steps, we can lift the restriction on the value of the cell and enter the content normally. Have you learned it? If you have a computer at hand now, then open Microsoft Office Excel and try to limit the cells and release it!

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