（视频）表格打印技巧合集（更新中）：如何打印数据透视表 选定区域
<b>视频地址1：</b>点击观看<br><br><b>视频地址2：</b>点击观看<br><br>
<b>教程难度：</b>初级<br><br>
<b>图文教程：</b><br>
<p style="white-space: normal;"><br></p><p style="white-space: normal;"><span style="font-size: 16px; font-family: 微软雅黑, Microsoft YaHei; text-decoration-line: underline; box-sizing: border-box; padding: 0px; margin: 0px; background-color: rgb(255, 255, 255); color: rgb(128, 100, 162);"></span></p><p><span style="font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;">在打印数据透视表时，有时我们只想打印数据透视表的部分区域，那该如何操作呢？</span></p><p><span style="font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;"><br></span></p><p><span style="font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;"><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/bccf8f501a092ee62d67745e209abab1.png" title="教程分界线.png" alt="教程分界线.png"></span></p><p><span style="font-family: 微软雅黑, Microsoft YaHei;"><span style="font-family: 微软雅黑; font-size: 16px;">▪</span><span style="font-size: 16px; font-family: 汉仪正圆-55W;">以此数据透视表为例，若我们只想打印销售人员与物品销售量区域。</span></span></p><p style="margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;text-indent:0;padding:0 0 0 0 ;background:rgb(255,255,255)"><span style="font-family: 微软雅黑, Microsoft YaHei;"><span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 微软雅黑;">选中</span><span style="font-size: 16px; font-family: 汉仪正圆-55W;">销售人员与物品销售量区域，</span><span style="font-family: 汉仪正圆-55W; color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px;"><span style="font-family: 汉仪正圆-55W;">点击上方菜单栏页面布局</span>-打印区域-设置打印区域<span style="font-family: 汉仪正圆-55W;">，就能将选中区域设置为可打印的区域。</span></span></span></p><p style="margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;text-indent:0;padding:0 0 0 0 ;background:rgb(255,255,255)"><span style="font-family: 汉仪正圆-55W; color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px;"><span style="font-family: 汉仪正圆-55W;">点击左上方</span>“打印预览”<span style="font-family: 汉仪正圆-55W;">按钮即可查看打印效果。</span></span></p><p style="margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;text-indent:0;padding:0 0 0 0 ;background:rgb(255,255,255)"><span style="font-family: 汉仪正圆-55W; color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px;"><span style="font-family: 汉仪正圆-55W;"><br></span></span></p><p style="margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;text-indent:0;padding:0 0 0 0 ;background:rgb(255,255,255)"><span style="font-family: 汉仪正圆-55W; color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px;"><span style="font-family: 汉仪正圆-55W;"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/f7bfd3486d91a87da164ebc04e37785d.gif" title="1.gif" alt="1.gif"></span></span></p><p style="margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;text-indent:0;padding:0 0 0 0 ;background:rgb(255,255,255)"><span style="font-family: 汉仪正圆-55W; color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px;"><span style="font-family: 汉仪正圆-55W;"><br></span></span></p><p style="margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;text-indent:0;padding:0 0 0 0 ;background:rgb(255,255,255)"><span style="font-family: 微软雅黑, Microsoft YaHei;"><span style="font-family: 微软雅黑; font-size: 16px;">▪</span><span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 微软雅黑;">我们也可直接选中</span><span style="font-size: 16px; font-family: 汉仪正圆-55W;">销售人员与物品销售量区域。</span></span></p><p style="margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;text-indent:0;padding:0 0 0 0 ;background:rgb(255,255,255)"><span style="font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;"><span style="font-size: 16px; font-family: 汉仪正圆-55W;">点击左上方</span>“打印”按钮，在弹出的“打印”界面中，设置打印内容为“选定区域”。</span></p><p><span style="font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;">点击确定，即可打印选定的销售人员与物品销售量区域。</span></p><p><span style="font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;"><br></span></p><p><span style="font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/2332de594050abdabe2ae840a4cdd39f.gif" title="2.gif" alt="2.gif"></span></p><p style="white-space: normal;"><span style="font-size: 16px; font-family: 微软雅黑, Microsoft YaHei; text-decoration-line: underline; box-sizing: border-box; padding: 0px; margin: 0px; background-color: rgb(255, 255, 255); color: rgb(128, 100, 162);"><br></span><br></p><p><span style="font-size: 16px; font-family: 微软雅黑, Microsoft YaHei; text-decoration-line: underline; box-sizing: border-box; padding: 0px; margin: 0px; background-color: rgb(255, 255, 255); color: rgb(128, 100, 162);"><br></span></p><p><br></p>
頁:
[1]