首先使用鼠标左键选中我们想要处理的单元格区域,如下图所示,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b7b02087bf40ad1aec0ba9d472c11dfa9ecceac?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/0bd162d9f2d3572cdec6e1a29a13632762d0c3ac?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/f3d3572c11dfa9ec5b0a2b6972d0f703918fc1ac?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/03087bf40ad162d93fca1f6201dfa9ec8a13cdac?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/8b13632762d0f7034496e8a218fa513d2697c5ac?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/7af40ad162d9f2d399355991b9ec8a136327ccac?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/10dfa9ec8a136327b1c9bf4d818fa0ec08fac7ac?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
本回答被网友采纳