首先打开WPS表格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9f2f070828381f308c361dc8b9014c086e06f0a0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
选择需要设置的单元格数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1e30e924b899a901241acb570d950a7b0208f5a0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
点击菜单栏里数据选项。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/29381f30e924b899ce13e9597e061d950a7bf6a0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
然后点击有效性。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/060828381f30e924de8b0c505c086e061d95f7a0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
根据需要设置数据条件。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e824b899a9014c080714b8c41a7b02087bf4f4a0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
点击右下角确定即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7af40ad162d9f2d3263eb48eb9ec8a136327cca0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
输入设置以外的数据会错误提示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4d086e061d950a7b6e1adea51ad162d9f2d3c9a0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
END
总结
1、首先打开WPS表格。
2、选择需要设置的单元格数据。
3、点击菜单栏里数据选项。
4、然后点击有效性。
5、根据需要设置数据条件。
6、点击右下角确定即可。
7、输入设置以外的数据会错误提示。
温馨提示:答案为网友推荐,仅供参考