1、打开需要进行数据有效性设置的表格,在这里自行先制作了一个表格
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3ac79f3df8dcd100f4ceaac77c8b4710b8122f81?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、选中性别这一列的内容,点击“数据”,选择“有效性”
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/738b4710b912c8fc97a1a42bf2039245d7882181?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、选择性别的有效性条件为“序列”,在来源中设置为“男,女”,需要注意的是中间逗号为英文逗号
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f9dcd100baa1cd1122da20c6b712c8fcc2ce2de3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击确定后,可以看到表中出现列表的箭头,下拉可以选择男还是女,如下图所示:(当分类较多的时候就不用重复的输入,简单的设置一下数据的有效性就节省了很多时间)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef44453cab8d3c451da80cb3e98?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、本例中的身份证存在着不细心很容易输错的情况,时常有人多输入一位数字或者少输入一位,为避免这样的情况,还可以对身份证号进行设置,比如身份证号一般18位数字,首先对身份证号那一栏设为文本格式
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8014c086e061d95a16b65de75f40ad162d9ca23?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)