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