原因可能如下:
1、右边可能有合并单元格,可能被合并的,一部分打印时被隐藏了。
2、打印预览时不显示边框不要紧只要打出来有边框即可。如果打出来不显示边框,请尝试缩小打印范围或者是缩小页边距 。
3、打印预览时,会对显示内容自动缩小,以保证完整的显示一整页“纸”。此时不仅是表格线,包括文字的横笔画所在的行,都有可能在缩小显示时,被抽取省略掉。不过这不会影响到内容的打印。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b7b02087bf40ad1c8009fb85a2c11dfa8ecce81?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
扩展资料
设置边框:
1、启动excel,选定要设置边框的区域;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0ff41bd5ad6eddc40c5feca034dbb6fd52663334?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/d31b0ef41bd5ad6e81413cb18ccb39dbb6fd3c34?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/6d81800a19d8bc3e82e85e918f8ba61ea9d3458c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)