如果我们需要用Excel批量删除空行的情况下,怎么操作比较方便?来看看软件帝www.ruanjiandi.com为你准备的操作教程吧!
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e1fe9925bc315c6088cb8eb882b1cb134954770f?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/279759ee3d6d55fbe457937162224f4a21a4ddd0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
1、全选表格,按CTRL+G打开【定位】框。
2、点击【定为条件】,选择【空值】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/58ee3d6d55fbb2fb14babd45404a20a44723dcd0?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/503d269759ee3d6d0057629c4c166d224e4aded0?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/9825bc315c6034a8e3bc5dd6c41349540923760f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、最后,表格中所有的空行数据就被删除了,表格也自动变成一个完整的表格了。
以上就是软件帝为各位准备的Excel批量删除空行的教程,希望可以帮助到您!