Home  >  Article  >  Topics  >  Where to set up data validation in excel2010?

Where to set up data validation in excel2010?

烟雨青岚
烟雨青岚Original
2020-06-24 14:41:5423663browse

Where to set up data validation in excel2010?

#Where to set up data validation in excel2010?

excel2010 data validation is set in "Data Validation" on the "Data" panel in the menu bar.

Setting steps:

1. First, we open excel, and then set the cell range for data validity. Select the cells we need.

Where to set up data validation in excel2010?

2. In this interface, we click on the data in the toolbar and select data verification

Where to set up data validation in excel2010?

3. In the data validation that pops up, choose to set the validation conditions for data validation. Set an integer between 1-35. Click the drop-down arrow on the right side below Allow

Where to set up data validation in excel2010?

4. Set the data, select between, and then we set the corresponding data in the minimum and maximum values ​​below

Where to set up data validation in excel2010?

Recommended tutorial: "excel tutorial"

The above is the detailed content of Where to set up data validation in excel2010?. 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