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.

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

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

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

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!