A simple way to undo illegal input values ​​in Excel tables

php editor Baicao introduces you a simple and effective method to delete input values ​​in Excel tables. In Excel, sometimes we need to clear the value of a certain cell or a column of cells, but do not want to delete other formats or functions. In this case, we can use special methods to achieve rapid numerical clearing, eliminating the tedious operation of manually deleting one by one, and improving work efficiency. This simple method will be introduced in detail below so that you can easily master it and apply it to actual work.

1. Open our form and enter a data in the cell to be modified. You will find that a button with illegal input value 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, you need to cancel the reminder in the error warning or modify the maximum value in the settings. If you want 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. Enter the prompt content we want to remind the user in the error warning.

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

The above is the detailed content of A simple way to undo illegal input values ​​in Excel tables. For more information, please follow other related articles on the PHP Chinese website!