（视频）表格打印技巧合集（更新中）：如何打印数据透视表的 标题表头
<b>视频地址1：</b>点击观看<br><br><b>视频地址2：</b>点击观看<br><br>
<b>教程难度：</b>初级<br><br>
<b>图文教程：</b><br>
<p><br></p><p><span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; background: rgb(255, 255, 255); font-family: 微软雅黑, Microsoft YaHei;">在打印数据透视表的过程中，遇到数据表格过多，打印出来的数据透视表没有标题或者表头，该如何解决呢？</span></p><p><span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; background: rgb(255, 255, 255); font-family: 微软雅黑, Microsoft YaHei;"><br></span></p><p><span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; background: rgb(255, 255, 255); font-family: 微软雅黑, Microsoft YaHei;"><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/bccf8f501a092ee62d67745e209abab1.png" title="教程分界线.png" alt="教程分界线.png"></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: 微软雅黑; color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px;">▪</span><span style="color: rgb(34, 34, 38); letter-spacing: 0px; 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="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;">我们可见因为数据过多，此数据透视表需要分多页打印，除首页外，其余页面是没有标题和表头的。</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="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;"><br></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="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/60bd7a9d8f4e82c951a334cbd345015a.gif" title="1.gif" alt="1.gif"></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="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;"><br></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: 微软雅黑; color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px;">▪</span><span style="color: rgb(34, 34, 38); letter-spacing: 0px; 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="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;"><span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 汉仪正圆-55W;">点击上方菜单栏页面布局</span>-打印标题和表头<span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 汉仪正圆-55W;">，在弹出的页面设置对话框中，可以看到有</span>“打印标题”的区域选项<span style="color: rgb(34, 34, 38); letter-spacing: 0px; 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="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;"><span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 汉仪正圆-55W;">在</span>“顶端标题行”中输入需要固定打印的标题行就可以了<span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 汉仪正圆-55W;">。</span></span></p><p style="margin: 0px; text-indent: 0px; padding: 0px; background: rgb(255, 255, 255);"><span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;"><span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 汉仪正圆-55W;">点击下方</span>“打印预览”，即可预览设置好的效果<span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 汉仪正圆-55W;">。</span></span></p><p style="margin: 0px; text-indent: 0px; padding: 0px; background: rgb(255, 255, 255);"><span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;"><span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 汉仪正圆-55W;"><br></span></span></p><p style="margin: 0px; text-indent: 0px; padding: 0px; background: rgb(255, 255, 255);"><span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 微软雅黑, Microsoft YaHei;"><span style="color: rgb(34, 34, 38); letter-spacing: 0px; font-size: 16px; font-family: 汉仪正圆-55W;"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/21db0529e4ade903ab966bc496fce26c.gif" title="2.gif" alt="2.gif"></span></span></p>
頁:
[1]