如何将又细又长的表格，打印在一张纸上？
<div class="wx_rich_media_content" id="jsWxContainer"><section data-mpa-powered-by="yiban.io"><section style="margin-right: 16px; margin-bottom: 0em; margin-left: 16px; outline: 0px; letter-spacing: 0.544px; clear: both; min-height: 1em; font-family: -apple-system-font, system-ui, "Helvetica Neue", ";P<br></section><pre ng-bind-html="message.MMActualContent" style="outline: 0px; color: rgb(34, 34, 34); letter-spacing: 0.544px; font-size: 16px; visibility: visible;"><section style="margin-right: 16px;margin-left: 16px;outline: 0px;clear: both;min-height: 1em;font-size: 17px;white-space: normal;font-family: -apple-system, BlinkMacSystemFont, "Helvetica Neue", ";P<h1 style="outline: 0px;white-space: pre-wrap;font-family: monospace;letter-spacing: 0.544px;visibility: visible;"><section style="margin-bottom: 0em;outline: 0px;text-align: center;visibility: visible;"><span class="wxart_image" wx-style="display:inline-block;outline: 0px;display: initial;box-sizing: border-box !important;visibility: visible !important;width: 546px;height: 740px;"></span></section></h1><section data-role="outer" label="Powered by 135editor.com" style="outline: 0px;letter-spacing: 0.544px;visibility: visible;"><section data-id="87922" data-tools="135编辑器" style="outline: 0px;visibility: visible;"><section style="outline: 0px;visibility: visible;"><section style="outline: 0px;visibility: visible;"><pre ng-bind-html="message.MMActualContent" style="outline: 0px;visibility: visible;"><h1 style="outline: 0px;letter-spacing: 0.544px;white-space: pre-wrap;visibility: visible;"><section style="outline: 0px; clear: both; min-height: 1em; letter-spacing: 0.544px; font-family: -apple-system, BlinkMacSystemFont, "Helvetica Neue", ";P<br></section></h1></pre></section></section></section></section></section></pre><p style="margin-right: 16px; margin-left: 16px; outline: 0px; line-height: 1.75em; visibility: visible;"><span style="outline: 0px;color: rgb(253, 134, 92);visibility: visible;"><strong style="outline: 0px;visibility: visible;"><span style="outline: 0px;font-family: "Helvetica Neue", Helvetica, "Hiragino Sans GB", "Microsoft YaHei", Arial, sans-serif;font-size: 15px;letter-spacing: 1px;visibility: visible;">大家好，我是职叔。</span></strong></span></p><p style="margin-right: 16px; margin-left: 16px; outline: 0px; visibility: visible; line-height: normal;"><span style="outline: 0px;color: rgb(253, 134, 92);visibility: visible;"><strong style="outline: 0px;visibility: visible;"><span style="outline: 0px;font-family: "Helvetica Neue", Helvetica, "Hiragino Sans GB", "Microsoft YaHei", Arial, sans-serif;font-size: 15px;letter-spacing: 1px;visibility: visible;"><br></span></strong></span></p><p style="margin-right: 16px; margin-left: 16px; outline: 0px; visibility: visible; line-height: normal;"><span style="outline: 0px;color: rgb(253, 134, 92);visibility: visible;"><strong style="outline: 0px;visibility: visible;"><span style="outline: 0px;font-family: "Helvetica Neue", Helvetica, "Hiragino Sans GB", "Microsoft YaHei", Arial, sans-serif;font-size: 15px;letter-spacing: 1px;visibility: visible;"><br></span></strong></span></p><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span style="font-size: 15px;letter-spacing: 2px;">有时候在Excel中制作的表格，</span><span style="font-size: 15px;letter-spacing: 2px;color: rgb(253, 134, 92);"><strong>数据比较单一，而且还占据几页，看起来又细又长。</strong></span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span style="font-size: 15px;letter-spacing: 2px;">就这样打印的话，每一页就只有一点内容，大部分是空白，太浪费纸张了。</span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;text-align: center;"><span class="wxart_image" wx-style="display:inline-block;outline: 0px;display: initial;box-sizing: border-box !important;overflow-wrap: break-word !important;visibility: visible !important;width: 510px !important;"></span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span style="font-size: 15px;letter-spacing: 2px;">有什么好的方法，能够让这些数据打印在一页纸上面呢？</span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span style="font-size: 15px;letter-spacing: 2px;">这里，职叔就给大伙们分享两种不错的方法！</span></section><section style="margin-left: 16px; margin-right: 16px; line-height: normal;"><br></section><section style="text-align: center;margin-left: 16px;margin-right: 16px;"><span class="wxart_image" wx-style="display:inline-block;"></span></section><section><section><section><section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;text-align: center;"><strong><span style="font-size: 15px;letter-spacing: 2px;background-color: rgb(253, 134, 92);color: rgb(255, 255, 255);">查找和替换</span></strong></section></section></section></section></section><section style="margin-left: 16px; margin-right: 16px; line-height: normal;"><br></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span style="font-size: 15px;letter-spacing: 2px;">在旁边的C2单元格输入A2，然后向右填充到H2单元格，在第二行继续填充，下拉。</span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span class="wxart_image" wx-style="display:inline-block;outline: 0px;display: initial;box-sizing: border-box !important;overflow-wrap: break-word !important;visibility: visible !important;width: 650px !important;"></span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span style="font-size: 15px;letter-spacing: 2px;">使用快捷键</span><span style="font-size: 15px;letter-spacing: 2px;color: rgb(253, 134, 92);"><strong>「Ctrl + H」</strong></span><span style="font-size: 15px;letter-spacing: 2px;">，打开“查找和替换”，查找内容输入“a”，“替换为”设为“=a”，点击“全部替换”，然后删除没用单元格。</span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span class="wxart_image" wx-style="display:inline-block;outline: 0px;display: initial;box-sizing: border-box !important;overflow-wrap: break-word !important;visibility: visible !important;width: 650px !important;"></span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span style="color: rgb(253, 134, 92);"><strong><span style="font-size: 15px;letter-spacing: 2px;">全选表格，然后复制，将其粘贴为“值”，</span></strong></span><span style="font-size: 15px;letter-spacing: 2px;">删除之前的单元格。</span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span class="wxart_image" wx-style="display:inline-block;outline: 0px;display: initial;box-sizing: border-box !important;overflow-wrap: break-word !important;visibility: visible !important;width: 650px !important;"></span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span style="font-size: 15px;letter-spacing: 2px;">最终效果。</span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span class="wxart_image" wx-style="display:inline-block;outline: 0px;display: initial;box-sizing: border-box !important;overflow-wrap: break-word !important;visibility: visible !important;width: 510px !important;"></span></section><section style="margin-left: 16px; margin-right: 16px; line-height: normal;"><br></section><section style="text-align: center;margin-left: 16px;margin-right: 16px;"><span class="wxart_image" wx-style="display:inline-block;"></span></section><section><section><section><section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;text-align: center;"><strong><span style="font-size: 15px;letter-spacing: 2px;background-color: rgb(253, 134, 92);color: rgb(255, 255, 255);">Word中分栏</span></strong></section></section></section></section></section><section style="margin-left: 16px; margin-right: 16px; line-height: normal;"><br></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span style="font-size: 15px;letter-spacing: 2px;">将表格复制到Word文档中。</span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span class="wxart_image" wx-style="display:inline-block;outline: 0px;display: initial;box-sizing: border-box !important;overflow-wrap: break-word !important;visibility: visible !important;width: 650px !important;"></span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span style="font-size: 15px;letter-spacing: 2px;">进入</span><span style="font-size: 15px;letter-spacing: 2px;color: rgb(253, 134, 92);"><strong>「布局」-「页面设置」-「栏」-「更多栏」</strong></span><span style="font-size: 15px;letter-spacing: 2px;">，我们这里设置成“6”栏，确定。（大家可以根据自己需求来设定。）</span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span class="wxart_image" wx-style="display:inline-block;outline: 0px;display: initial;box-sizing: border-box !important;overflow-wrap: break-word !important;visibility: visible !important;width: 650px !important;"></span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span style="font-size: 15px;letter-spacing: 2px;">将光标定位到第一个单元格中，进入</span><span style="font-size: 15px;letter-spacing: 2px;color: rgb(253, 134, 92);"><strong>「布局」-「数据」-「重复标题行」。</strong></span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span class="wxart_image" wx-style="display:inline-block;outline: 0px;display: initial;box-sizing: border-box !important;overflow-wrap: break-word !important;visibility: visible !important;width: 650px !important;"></span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;"><span style="font-size: 15px;letter-spacing: 2px;">最终效果如下。</span></section><section style="margin-left: 16px;margin-right: 16px;margin-bottom: 24px;line-height: 1.75em;text-align: center;"><span class="wxart_image" wx-style="display:inline-block;outline: 0px;display: initial;box-sizing: border-box !important;overflow-wrap: break-word !important;visibility: visible !important;width: 512px !important;"></span></section><pre ng-bind-html="message.MMActualContent" style="outline: 0px; color: rgb(34, 34, 34); letter-spacing: 0.544px; caret-color: rgba(0, 0, 0, 0); text-align: center; visibility: visible;"><section style="outline: 0px; letter-spacing: 0.544px; white-space: normal; font-family: -apple-system, BlinkMacSystemFont, "Helvetica Neue", ";P<section powered-by="xiumi.us" style="outline: 0px;letter-spacing: 0.544px;"><section data-role="outer" label="Powered by 135editor.com" style="outline: 0px;letter-spacing: 0.544px;"><p style="margin-right: 16px; margin-left: 16px; outline: 0px; line-height: normal;"><br data-filtered="filtered" style="outline: 0px;"></p><section class="mp_profile_iframe_wrp" style="outline: 0px;"><mp-common-profile data-index="0" data-id="MzU4MTQ0NzcyNw==" data-headimg="http://mmbiz.qpic.cn/mmbiz_png/jmjAT6spoGf3UpybPIxXLYe8Sf0ldmC5E0Bdiby436Oib1ibWR2G7G2kWwJia4ZQfNg8pAP0rj1cFBqjRiaUPLg1icjA/0?wx_fmt=png" data-nickname="办公技巧专家" data-alias="SuperOfficeSkill" data-signature="有态度、有温度、有深度的内容，关注我就能看到！持续性分享职场办公小技巧，还能帮你激活正版Office软件哦~" data-origin_num="7" data-is_biz_ban="0" data-isban="0" class="js_wx_tap_highlight" data-from="2"></mp-common-profile></section><p style="margin: 0em 16px;outline: 0px;letter-spacing: 0.544px;line-height: normal;"><br data-filtered="filtered" style="outline: 0px;"></p><p style="margin-right: 16px; margin-bottom: 0em; margin-left: 16px; outline: 0px; letter-spacing: 0.544px; line-height: normal;"><br></p><p style="margin-right: 8px; margin-bottom: 0em; margin-left: 8px; outline: 0px; letter-spacing: 0.544px; font-family: -apple-system-font, BlinkMacSystemFont, "Helvetica Neue", ";P<br></p></section></section></section><pre accuse="aContent" style="letter-spacing: 0.544px; outline: 0px;"><h2 placeholder="请输入标题" style="outline: 0px;font-family: -apple-system, BlinkMacSystemFont, "Helvetica Neue", ";P<pre accuse="aContent" style="outline: 0px;font-size: 17px;letter-spacing: 0.544px;white-space: normal;"><pre accuse="aContent" style="outline: 0px;letter-spacing: 0.544px;white-space: normal;"><section style="margin-top: 5px;margin-right: 16px;margin-left: 16px;outline: 0px;font-family: -apple-system, BlinkMacSystemFont, "Helvetica Neue", ";P<section hm_fix="333:236" style="margin: 10px auto;outline: 0px;display: flex;justify-content: space-between;align-items: flex-end;"><section style="outline: 0px;display: flex;justify-content: center;align-items: flex-end;"><section style="outline: 0px;width: auto;"><section style="margin-right: auto;margin-left: auto;outline: 0px;width: 35px;"><span class="wxart_image" wx-style="display:inline-block;outline: 0px;box-sizing: border-box;display: block;visibility: visible !important;width: 35px !important;"><br></span></section></section></section></section></section></pre></pre></h2><h2 placeholder="请输入标题" static="" image="" smiley="" default="" titter.gif"="" border="0" smilieid="9" alt="<img src="><br><pre accuse="aContent" style="margin: 0px; padding: 0px; overflow-wrap: break-word; outline: 0px; letter-spacing: 0.544px; white-space: normal;"><section static="" image="" smiley="" default="" titter.gif"="" border="0" smilieid="9" alt="<img src="><section style="margin: 0px; padding: 0px; overflow-wrap: break-word; outline: 0px; display: flex; justify-content: center; align-items: flex-end;"><section style="margin: 0px; padding: 0px; overflow-wrap: break-word; outline: 0px; width: auto;"><section style="margin: 0px auto; padding: 0px; overflow-wrap: break-word; outline: 0px; width: 25px;"><br></section></section></section></section></pre></h2></pre></pre></section><h2 placeholder="请输入标题" style="outline: 0px;font-family: -apple-system, BlinkMacSystemFont, "Helvetica Neue", ";P<pre accuse="aContent" style="outline: 0px;font-size: 17px;letter-spacing: 0.544px;white-space: normal;"><pre accuse="aContent" style="outline: 0px;letter-spacing: 0.544px;white-space: normal;"><section style="margin-top: 5px;margin-right: 16px;margin-left: 16px;outline: 0px;font-family: -apple-system, BlinkMacSystemFont, "Helvetica Neue", ";P<section hm_fix="333:236" style="margin: 10px auto;outline: 0px;display: flex;justify-content: space-between;align-items: flex-end;"><section style="outline: 0px;display: flex;justify-content: center;align-items: flex-end;"><section style="outline: 0px;width: auto;"><section data-brushtype="text" style="outline: 0px;font-size: 14px;letter-spacing: 1.5px;color: rgb(0, 0, 0);"><p style="margin-right: 8px;margin-left: 8px;outline: 0px;line-height: 1.75em;letter-spacing: 1px;"><span style="outline: 0px;color: rgb(63, 63, 63);font-family: "Helvetica Neue", Helvetica, "Hiragino Sans GB", "Microsoft YaHei", Arial, sans-serif;font-size: 15px;letter-spacing: 2px;"><strong style="outline: 0px;">点分享</strong></span></p></section></section><section style="margin-left: 10px;outline: 0px;width: auto;"><section style="margin-right: auto;margin-left: auto;outline: 0px;width: 30px;"><br></section><section data-brushtype="text" style="outline: 0px;font-size: 14px;letter-spacing: 1.5px;color: rgb(0, 0, 0);"><p style="margin-right: 8px;margin-left: 8px;outline: 0px;line-height: 1.75em;letter-spacing: 1px;"><span style="outline: 0px;color: rgb(63, 63, 63);font-family: "Helvetica Neue", Helvetica, "Hiragino Sans GB", "Microsoft YaHei", Arial, sans-serif;font-size: 15px;letter-spacing: 2px;"><strong style="outline: 0px;">点收藏</strong></span></p></section></section></section></section></section></pre></pre></h2>转载声明：本文转载自「办公技巧专家」，搜索「SuperOfficeSkill」即可关注，[<a target="_blank" href="https://mp.weixin.qq.com/s/uKWmSWJUuxf8N1ta1z0t3w">阅读原文</a>]。</div><p></p>
页:
[1]