打印excel表格打印不全,有一部分在另外一页,解决步骤如下:
工具:电脑window 7、excel。
1、首先在电脑上面找到需要设置的表格,找到之后选中表格,单击右键选择打开。
![](https://iknow-pic.cdn.bcebos.com/e4dde71190ef76c67b1653bd8f16fdfaae516764?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、打开页面之后,点击页面布局工具。
![](https://iknow-pic.cdn.bcebos.com/34fae6cd7b899e513949928250a7d933c9950d64?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、接着在页面布局这一栏下方找到打印区域这个选项,并点击此选项。
![](https://iknow-pic.cdn.bcebos.com/b151f8198618367a844ed74b3c738bd4b21ce565?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击了之后,就会弹出两个选项子菜单,点击设置打印区域这个选项。
![](https://iknow-pic.cdn.bcebos.com/6a600c338744ebf886b6cca9cbf9d72a6159a765?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、设置了之后,就可以显示打印的区域里面的内容,超出了这个区域的内容,那么就是无法显示出来的。
![](https://iknow-pic.cdn.bcebos.com/b3b7d0a20cf431ad0815ebaf5936acaf2fdd9865?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、接着点击页面布局下面的页面缩放这个选项。
![](https://iknow-pic.cdn.bcebos.com/91ef76c6a7efce1b43ec605cbd51f3deb58f6565?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、然后选择自定义,并在页面里面将调整为这一栏选择为:将整个工作表打印在一页,这样就可以显示完整了。
![](https://iknow-pic.cdn.bcebos.com/810a19d8bc3eb135cc001f2db41ea8d3fc1f4465?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)