（视频）表格打印技巧合集（更新中）：表格如何按照类别 分页打印
<b>视频地址1：</b>点击观看<br><br><b>视频地址2：</b>点击观看<br><br>
<b>教程难度：</b>初级<br><br>
<b>图文教程：</b><br>
<p><span style="font-family: 微软雅黑; font-size: 19px;">我们在打印表格时，有时需要按照表格中的类别，分页打印表格。</span><br></p><p><span style=";font-family:微软雅黑;font-size:19px"><span style="font-family:微软雅黑">那该如何操作呢？</span></span></p><p><span style=";font-family:微软雅黑;font-size:19px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:19px"><span style="font-family:微软雅黑"><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/bccf8f501a092ee62d67745e209abab1.png" title="教程分界线.png" alt="教程分界线.png"></span></span></p><p><span style=";font-family:微软雅黑;font-size:19px">▪</span><span style=";font-family:微软雅黑;font-size:19px"><span style="font-family:微软雅黑">以此销售表格为例，首先要对表格数据分类汇总。</span></span></p><p><span style=";font-family:微软雅黑;font-size:19px"><span style="font-family:微软雅黑">选中数据区域，点击上方菜单栏数据</span>-分类汇总。</span></p><p><span style=";font-family:微软雅黑;font-size:19px"><span style="font-family:微软雅黑">在弹出的对话框中，选择分类字段，例如</span>“产品”；选择汇总方式，例如“求和”；选择汇总项，例如“销售量”；勾选“每组数据分页”。</span></p><p><span style=";font-family:微软雅黑;font-size:19px"><span style="font-family:微软雅黑">点击确定就可以对此表格进行分类汇总了。</span></span></p><p><span style=";font-family:微软雅黑;font-size:19px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:19px"><span style="font-family:微软雅黑"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/9a66a1b91773d8ca9cc47432f90e7dc3.gif" title="1.gif" alt="1.gif"></span></span></p><p><span style=";font-family:微软雅黑;font-size:19px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:19px">▪</span><span style=";font-family:微软雅黑;font-size:19px"><span style="font-family:微软雅黑">我们也可设置固定标题行。</span></span></p><p><span style=";font-family:微软雅黑;font-size:19px"><span style="font-family:微软雅黑">点击上方菜单栏页面布局</span>-打印标题或表头。</span></p><p><span style=";font-family:微软雅黑;font-size:19px"><span style="font-family:微软雅黑">在弹出的对话框中，输入顶端标题行，点击打印预览，此时我们可以预览表格按照类别分页打印的效果了。</span></span></p><p><br></p><p><img src="//res1.wpsacdm.cache.wpscdn.cn/images/61972bc2d20b897ff783fc1c039b0b2f.gif" title="2.gif" alt="2.gif"></p>
頁:
[1]