1、我们首先选择鼠标单击打开我们制作的EXCEL表格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd5612e26455fda81cb39db3d06?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/adaf2edda3cc7cd9fd54fa683701213fb80e9102?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/71cf3bc79f3df8dc68a64120c311728b461028ec?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/7acb0a46f21fbe0957f20da565600c338644add7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、例如,ID号通常是18位数。我们首先将ID号的单元格格式设置为文本。因为超过11位数字将用科学记数法表示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/060828381f30e924aa05528042086e061c95f7da?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、然后我们可以设置ID卡单元格中数据的有效性。设置数据有效性的条件是文本长度,数据长度设置为18。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4b90f603738da977c7c9489abe51f8198718e39a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)