If you are not familiar with the operation of undoing illegal input values ​​​​in Excel tables, let’s learn how to undo illegal input values ​​​​in Excel tables below. I hope it can help you.

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

2. 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, 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 clear 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. Enter the prompt content we want to remind the user in the error warning.

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

Above, I have shared with you how to undo illegal input values ​​in Excel tables. Friends in need should hurry up and read this article.