最佳答案:1、在电脑端打开excel表格,选中要填充为0的表格, 如下图所示。2、在选中表格之后点击ctrl+G快捷键,调出定位对话框。3、在弹出的定位对话框中,点击左下角定位条件按钮,选择空值选项按钮。4、确
1、在电脑端打开excel表格,选中要填充为0的表格, 如下图所示。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlLzJiMmEwMDAwM2NhMjVjZjE2OGNlOQ.jpg)
2、在选中表格之后点击ctrl+G快捷键,调出定位对话框。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlLzJiMjk5MDAwM2NhMTNjZmRjMDQwOQ.jpg)
3、在弹出的定位对话框中,点击左下角定位条件按钮,选择空值选项按钮。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlLzJiMjhlMDAwM2NiNjdhY2I1YjU4ZA.jpg)
4、确认之后弹出如下界面,即为定位所有空值。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlLzJiMjkxMDAwM2M3ZGU1YjhlZjk2Mg.jpg)
5、然后在单元格中输入数字0,然后按住CTRL键不放,再点击enter回车键。所有空白的单元格都填充为0,如下图所示。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlLzJiMjljMDAwM2NhNzUxZGVkZDQyNA.jpg)
6、也可使用查找和替换功能,按CTRL+h快捷键调出对话框,在替换一栏空着不要输入内容,在替换为一栏输入0,选择全部替换选项按钮即可。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlLzJiMjg0MDAwM2M4MzcyOTgwMDhiOQ.jpg)
7、设置完成之后,替换完成之后,系统会提示替换了几处,然后你的单元格空白处就被填充为0,如下图所示。
![](https://www.89179.net/other_image/aHR0cHM6Ly9wMy5kb3V5aW5waWMuY29tL2xhcmdlLzJiMjg1MDAwM2NhNjI4ZDk0NTkyOA.jpg)