excel点击表格任意位置,在键盘输入CTRL+F快捷键。输入快捷键后弹出了【查找】对话框,举例要查找“水桶”。在【查找内容】空白行内输入“水桶”,点击【查找全部】。查找内容的具体位置会显示出来。
工具/原料:
雷神DESKTOP-ABUINPS
Windows10
WPS Office办公软件2019
1、excel点击表格任意位置。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/78310a55b319ebc4f500eb0c9026cffc1e17162e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在键盘输入CTRL+F快捷键。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/42a98226cffc1e17cdc711a45890f603738de92f?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/4bed2e738bd4b31cdf44092e95d6277f9e2ff82f?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/8718367adab44aed7b362371a11c8701a18bfb2f?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/4b90f603738da97774571bbea251f8198618e32f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、查找内容的具体位置会显示出来。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3812b31bb051f819d75d9edfc8b44aed2e73e72f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、查找内容的单元格也会显示被选定的状态。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1f178a82b9014a90bc46db28bb773912b31bee2f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)