How does Excel set clear data validation? The validity of the data is set in the table, and we will not be able to fill in any other error. Modify the table to determine the validity of the data, it is necessary to clear the data validation settings, the following small series for you to introduce, to see!
Fill in the content failed, but we are sure that we fill in the content without errors.
Select the cells you want to modify and click the data in the main menu-data validation. In the bottom left corner of the pop-up menu there is "all clear", click OK.
In the file more than set the validity, we do not need the entire document, the deletion efficiency is too slow. We use positioning to select all the cells that have data validation settings. In the Start menu-Find and select-position criteria. or shortcut key ctrl+g, pop-up positioning menu, click on positioning conditions.
Select the data validation in the Location menu-all, click OK.
In this way, the cells that have validity settings in the file are all selected.
We're going to click on the data Validation menu at this point and pop up the "Select area contains multiple data validation" prompt box, OK.
When the Data validation menu pops up, it's slightly different when you know a cell, or the same click Setting-all clear so that all the validation settings in the entire file are deleted.
The above is how to set up a clear data validation method Introduction, the operation is very simple, we have learned? I hope this article can help!