What should I do if other users have restricted the values ​​that can be entered in this cell?

Solution to "Other users have restricted the value that can be entered in this cell": First open the Excel document; then enter some values ​​in the table that needs to be operated; then select the area that needs to be operated, and click above Select "Data" in the menu bar; finally select "Data Validation" in the data, and select "Any Value" in the validation conditions.

#The operating environment of this article: Windows7 system, Microsoft Office Excel2016, Dell G3 computer.

Enter some values ​​in the table that needs to be operated, and after pressing Enter, the following dialog box will pop up, indicating that "other users have limited the values ​​that can be entered in this cell." This is because the data validation format is set.

Select this cell (or the area that needs to be operated), and select "Data" in the upper menu bar.

Select "Data Verification" in the data, and among the three options that appear, select the first "Data Verification".

Select "Settings" in the pop-up dialog box, and select "Any value" in the verification conditions below.

After clicking Confirm, enter the data again and press Enter. No dialog box pops up.

Summary:

1. Enter some values ​​in the table that needs to be operated, and press Enter. The following dialog box will pop up, indicating that "Other users have restricted to enter the value of the cell." This is because the data validation format is set.

2. Select this cell (or the area that needs to be operated), and select "Data" in the upper menu bar.

3. Select "Data Verification" in the data. Among the three options that appear, select the first "Data Verification".

4. Select "Settings" in the pop-up dialog box, and select "Any value" in the verification conditions below.

5. After clicking Confirm, enter the data again and press Enter. No dialog box pops up.

Recommended: "Excel Tutorial"

The above is the detailed content of What should I do if other users have restricted the values ​​that can be entered in this cell?. For more information, please follow other related articles on the PHP Chinese website!