某些时候,由于粘贴录入等方面的原因,我们的表格数据中会出现大量的空白行或者列。如果一个个删除肯定是耗时耗力的,那有没有一种批量的方法呢?
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/908fa0ec08fa513d910333bf2d6d55fbb2fbd922?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/3c6d55fbb2fb4316d0b6251b30a4462309f7d322?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/58ee3d6d55fbb2fbff8207735f4a20a44623dc22?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/279759ee3d6d55fb096f29477d224f4a20a4dd22?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/f603918fa0ec08fae7a94cc649ee3d6d55fbda22?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/503d269759ee3d6def6fd8aa53166d224f4ade22?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/54fbb2fb43166d22f1de4af5562309f79052d222?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述