How to solve illegal input values ​​in Excel table

#How to solve the problem of illegal input values ​​in Excel table?

When we use the excel form sent to us by others, we sometimes find that the data cannot be modified in a certain cell, and a dialog box with illegal input value will pop up. Undo method;

1. Open our form, enter a data in the cell to be modified, and you will find that a button indicating that the input value is illegal pops up.

2. We select this cell, and then select Data - Validity in the menu. We will find that the maximum text length of this cell is 9, so we cannot continue to add text.

3. If you want to cancel the reminder, you need to cancel the reminder in the error warning or modify the maximum value in the settings. To cancel the reminder in the error warning, you need to cancel the check box in front of the error warning.

4. If we want to give others a form and don’t want others to fill it in randomly, we can also use this method directly. For example, we can set the size of the value in the specified cell.

5. Then enter the prompt content we want to remind the user in the error warning.

6. Then if we enter a value outside the range in this cell, the reminder we set will appear.

The above is the detailed content of How to solve illegal input values ​​in Excel table. For more information, please follow other related articles on the PHP Chinese website!