Excel数据验证

男娘i 2023-06-30 02:18 120阅读 0赞

假设我们在第一列数据中，需要键入性别的限制是“男”或者“女”。选中限制的单元格。点击【数据】-【数据工具】-【数据验证】

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfYmNjbDI3_size_16_color_FFFFFF_t_70][]

在弹出的对话框中选择【序列】

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfYmNjbDI3_size_16_color_FFFFFF_t_70 1][]

在【来源】中输入“男”,“女”。点击【确定】。注意，中间的逗号是在英文输入的情况下。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfYmNjbDI3_size_16_color_FFFFFF_t_70 2][]

这时我们就会发现有个下拉箭头，我们只需选择即可

![20200114093839962.png][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfYmNjbDI3_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200114093450839.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfYmNjbDI3,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfYmNjbDI3_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200114093708249.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfYmNjbDI3,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfYmNjbDI3_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200114093750205.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfYmNjbDI3,size_16,color_FFFFFF,t_70
[20200114093839962.png]: https://img-blog.csdnimg.cn/20200114093839962.png