问题已解决
老师一个表格中,有零值,怎么快速将零值全部删除
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/010/58/06/70_avatar_middle.jpg?t=1651204063)
你好,先把零头全部替换成空值
然后定位查找空值,右键删除就可以了
2020 04/05 07:31
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785004 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 04/05 18:41
操作路径呢
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785004 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 04/05 18:54
这样操作过后,那种20和30全部都变了
![](https://pic1.acc5.cn/010/58/06/70_avatar_middle.jpg?t=1651204063)
赵海龙老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 04/05 19:01
替换的时候选择单元格匹配
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785004 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 04/05 19:01
我这个找不到单元格匹配呀
![](https://pic1.acc5.cn/010/58/06/70_avatar_middle.jpg?t=1651204063)
赵海龙老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 04/05 19:07
看一下这个图片,不会的再问
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785004 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 04/05 19:13
收到,谢谢老师
![](https://pic1.acc5.cn/010/58/06/70_avatar_middle.jpg?t=1651204063)
赵海龙老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 04/05 19:15
不客气,以后有这方面的问题可以继续提问哦