操作方法如下:
1、打开excel表格,点击文件菜单中的打印选项;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0df431adcbef76098fe20fde23dda3cc7dd99e82?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/738b4710b912c8fcee7f4c93f1039245d78821db?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/8718367adab44aed5de404babe1c8701a08bfbc2?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/10dfa9ec8a136327eda6786d9c8fa0ec08fac721?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、设置合适的缩放比例点击确定。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5bafa40f4bfbfbedfcd58c2175f0f736aec31fdb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
扩展资料:
如何打印Excel表格制定部分:
1、首次打开需要的excel文件;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cb8065380cd791235bc6302aa0345982b2b7804e?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/6a600c338744ebf8b746c061d4f9d72a6059a7bd?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/c75c10385343fbf2770a027dbd7eca8065388f4e?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/6159252dd42a2834826f935556b5c9ea14cebfa7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、再点击左上角的黑色方框里的“打印预览”;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/500fd9f9d72a605996d944442534349b023bbaa7?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/d62a6059252dd42a9c3ea5f50e3b5bb5c9eab8bd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)