可以筛选空白单元格,一次性删除。
1、以excel2010版本为例,如图中的A列数据有不连续的空白单元格,现要删除,首先选中该列数据;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/77c6a7efce1b9d16c3e0ec98fedeb48f8c546427?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后点击页面右上方的“排序和筛选”,在弹出框里选择“筛选”;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8c1001e93901213f953e382559e736d12f2e953d?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/37d12f2eb9389b507b2796ab8835e5dde6116e6a?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/8c1001e93901213f94533f2559e736d12e2e95e2?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/8718367adab44aed90d5cf1dbe1c8701a08bfbb4?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/48540923dd54564ec0f695c0bede9c82d0584fb3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)