ARTICLE · 1375983
Excel表格分成2页?
今天我们学习,直接把整张表格压缩到1张A4,导出PDF也是单页!
页面布局提前固定
1. 顶部菜单点【页面】
2. 点开打印预览,弹出设置框<a class="wx_img_refer_link" data-seq="2" data-refer="图2" style="">图2</a>
3. 在【缩放】标签,缩放那里勾选所需<a class="wx_img_refer_link" data-seq="3" data-refer="图3" style="">图3</a>
4. 方向:纵向/横向按需切换,确定保存
5. 之后打印、导出PDF,都会自动适配在一页A4
进阶优化(字太小的时候这样调)
1. 优先横向 → 再调窄页边距,这两步比直接缩放更管用
2. 只需要全部列在一页、行可以多页:缩放设置【将所有列打印在一页】,这样不会把文字压得特别小<a class="wx_img_refer_link" data-seq="4" data-refer="图4" style="">图4</a>
<a href="https://mp.weixin.qq.com/s?__biz=MzcwNzQxMjkxNg==&mid=2247484282&idx=1&sn=7c7fd14fde1240753e996f36e05860f0&scene=142#wechat_redirect" class="normal_text_link mp_article_text_link" target="_blank">UNIQUE + FILTER 案例一:按客户提取订单</a>
<a href="https://mp.weixin.qq.com/s?__biz=MzcwNzQxMjkxNg==&mid=2247484150&idx=1&sn=76293d58ac74dfc56c77dd4e9ea13daa&scene=142#wechat_redirect" class="normal_text_link mp_article_text_link" target="_blank">Excel PIVOTBY完整长参数版教程</a>
<a href="https://mp.weixin.qq.com/s?__biz=MzcwNzQxMjkxNg==&mid=2247484228&idx=1&sn=7ee5740d5a8f1c7c05136691a1221462&scene=142#wechat_redirect" class="normal_text_link mp_article_text_link" target="_blank">Excel 从 VSTACK 到 XMATCH</a>
<a href="https://mp.weixin.qq.com/s?__biz=MzcwNzQxMjkxNg==&mid=2247484100&idx=1&sn=4ee9ae07d519aaea3bdcde8e2cf7e248&scene=142#wechat_redirect" class="normal_text_link mp_article_text_link" target="_blank">Excel【查找与引用】第二篇|FILTER、HLOOKUP、INDEX、INDIRECT、LOOKUP、MATCH等11个函数解析</a>
亲,别忘了右下角鼓励哦~
<a class="wx_topic_link" topic-id="topic_1793514334113_h9wx78yqe" style="color: var(--weui-LINK) !important;" data-topic="1" data-recommend="0">#公众号运营</a><a class="wx_topic_link" topic-id="topic_1793514342190_2hm9n9em3" style="color: var(--weui-LINK) !important;" data-topic="1" data-recommend="0">#Excel</a><a class="wx_topic_link" topic-id="topic_1793514349789_05406d2lq" style="color: var(--weui-LINK) !important;" data-topic="1" data-recommend="0">#流量主</a><a class="wx_topic_link" topic-id="topic_1793514364375_6wduei82t" style="color: var(--weui-LINK) !important;" data-topic="1" data-recommend="0">#新媒体运营</a><a class="wx_topic_link" topic-id="mwlu61g7-ovoyzh" style="color: var(--weui-LINK) !important;" data-topic="1" data-recommend="0">#日常一更</a>















































































