What is the validity of data in excel2016

How to set data validity in excel2016: First click "Data Validity" in "Data"; then select the corresponding allowed value in the validity condition and pull down the menu option; finally, you can select "Error Warning" ” option to set the warning style and title.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2016 version, Dell G3 computer.

How to set data validity in excel2016:

1. Click "Data Validity" in "Data", as shown in the figure:

2. Then select the corresponding allowed value in the validity condition, as shown in the figure:

3. If you select a sequence, you can Enter the sequence value in, separated by commas, and then press the "OK" button, as shown in the figure:

4. The result obtained by using the sequence is the drop-down menu option, as shown in the figure :

5. You can also set the warning style and title in the "Error Warning" option, as shown in the figure:

Related learning recommendations: excel tutorial

The above is the detailed content of What is the validity of data in excel2016. For more information, please follow other related articles on the PHP Chinese website!