1、有时候打开一个excel文件,发现表格如图所示,没有表格线,完全是一块白板,这给编辑带来了不方便。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2fdfc039245d68843e7ae02aac27d1ed31b24aa?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/9922720e0cf3d7ca712023d0fc1fbe096a63a945?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/fd039245d688d43f109d8e54731ed21b0ef43b5b?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/d058ccbf6c81800a6ad696a8bf3533fa828b4760?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳