1、举下列数据为例,先开启筛选按钮
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/78310a55b319ebc4fa47e2d68c26cffc1e171645?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、按类型进行筛选,筛选出所有类型为“A”的数据
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e1fe9925bc315c60d8e0ffa083b1cb134954770c?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/aec379310a55b319a765163a4da98226cefc17e4?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/0b55b319ebc4b7450ddf2359c1fc1e178a821531?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/d0c8a786c9177f3e6af768427ecf3bc79e3d56b9?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/aa18972bd40735fad515daf690510fb30e240893?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/9213b07eca806538b4f8335c99dda144ad34826b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、这时回到第6步,用复制
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4bed2e738bd4b31ce58003f489d6277f9f2ff8c5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
9、将复制好的数据黏贴在新的位置,并把原先选择的数据删除,已达到剪切目的
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3b87e950352ac65ca0b2f13cf5f2b21192138ace?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
10、这就实现把筛选出来的内容剪切,但不将表格全部剪切的效果了
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/caef76094b36acafe80a01b372d98d1000e99c93?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)