因输入内容不符合限制条件的取消步骤如下:
电脑:MacBook
系统:OSX 10.9
软件:WPS 2019
1、有的单元格输入内容后会提示不符合限制条件。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bd315c6034a85edfbca091b55b540923dd547573?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/f703738da97739122f09eaf7ea198618367ae27d?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/63d0f703918fa0eccbe90b9b349759ee3d6ddb7e?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/9213b07eca806538f0c2cb8585dda144ad348278?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、之后就能随意输入内容了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b90e7bec54e736d13a39e39e89504fc2d5626979?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
温馨提示:答案为网友推荐,仅供参考
相似回答
wps您输入的内容不符合限制条件答:1、当您单击单元格以输入数字时, "您输入的内容不符合限制"2、按 ESC 键返回计算机, 单击选择此单元格, 找到工作列数据验证有效性的下拉三角形有效性, 如圆圈所示, 点击此有效性,3、单击此有效性, 将显示下图, 在第三列中出现错误警告, 删除上面的钩子, 然后单击 "确定", 将恢复单元格。4、...