原因:没有设置打印页面的页边距,导致在打印时虚线框内无法完全覆盖需要打印的内容,页面CIA会自动缩小页面比例。
解决方法:
1、首先在Excel表格中可以看到在表格中间显示打印预览的虚线,可以看到需要打印的内容有部分在虚线框的外面。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6c224f4a20a4462340c574cf9622720e0cf3d714?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/e1fe9925bc315c609d98ba4283b1cb134954770a?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/2e2eb9389b504fc2465d61a8ebdde71190ef6d19?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/63d0f703918fa0ec35d4b5a0289759ee3d6ddb08?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、在打开的设置页边距的窗口中设置左右页边距为0。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1f178a82b9014a90e42e9710a7773912b31bee0f?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/a50f4bfbfbedab6401649c6df936afc379311e0c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)