Data Validation Basic Setup Tips

Data validation can standardize the user’s text and number input formats, such as only inputting values ​​in a specified range, only text data, limiting input spaces, limiting input of repeated values, etc. How to verify settings. After the data verification conditions are set, the data that meets the conditions is allowed to be input, and the data that does not meet the conditions is prohibited from being input. Therefore, this setting can be used to check the correctness and validity of the data and avoid inputting wrong data. In addition, you can also set the input prompt information How to verify the settings. That is, it reminds the data input of the selected cell; at the same time, it can also set an error warning message, that is, a warning message pops up when the input is wrong. This article mainly introduces ten tips for basic data verification settings: Give an input prompt when a cell is selected This example requires the input of “No. 1 High School Entrance Examination Results” in the list , in order to remind the inputter to input the data in the correct range, you can set the prompt text How to verify the settings…