1、新建一个需要查找后复制的【Excel表格】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/54fbb2fb43166d22f76d50eb562309f79052d2b3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、接下来需要在Excel表格中输入【数据】,如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/279759ee3d6d55fb07dc33597d224f4a20a4ddb3?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/42166d224f4a20a4fc0479b880529822720ed0b3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、按住快捷键【ctrl+g】,定位【可见单元格】,然后复制。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3c6d55fbb2fb4316da053f0530a4462309f7d3b3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、粘贴到新的位置后,【excel查找后全部复制】完成。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3fb43166d224f4a9983366c19f790529822d1b3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
扩展资料
复制快捷键Ctrl+C,剪切快捷键Ctrl+X,粘贴快捷键是Ctrl+V。
1、剪切:将图片或文字选中后,通过Ctrl+X命令,将图片或文字裁切下来,放到电脑剪切板上,再通过Ctrl+V粘贴到所要粘贴的位置。裁切文字的过程称为剪切。
2、复制粘贴,指将一个文本或一段文字复制后移动到另一个位置或另一个文本中。