How to set excel restrictions
- coldplay.xixiOriginal
- 2020-12-18 16:31:4676298browse
How to set excel restriction conditions: First select [Cell-Data-Validity]; then select Custom and enter the formula [=and(A2>=1,A2
The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
How to set excel restriction conditions:
1. Open the Excel table
2. Select the cell ——Data——Validity
3. Select Custom
4. Enter the formula =and(A2> ;=1,A2
5. Select Stop in the error warning and enter the warning message "Input error, please re-enter"
6. Input data test
#Related learning recommendations: excel basic tutorial
The above is the detailed content of How to set excel restrictions. 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
Previous article：How to automatically calculate totals in excel tablesNext article：How to automatically calculate totals in excel tables