Home  >  Article  >  Topics  >  What is the validity of data in excel2016

What is the validity of data in excel2016

coldplay.xixi
coldplay.xixiOriginal
2021-02-24 11:39:1928515browse

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.

What is the validity of data in excel2016

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:

What is the validity of data in excel2016

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

What is the validity of data in excel2016

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:

What is the validity of data in excel2016

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

What is the validity of data in excel2016

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

What is the validity of data in excel2016

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn