ARTICLE · 1371098
Excel打印设置2招:页面布局+打印区域,打印不翻车
本集操作路径:
③ 页面布局设置:页面布局 → 纸张方向「横向」→ 缩放「调整为1页宽×自动高」→ 页边距「窄」→ 打印预览
④ 打印区域与标题:选中数据区域 → 页面布局 → 打印区域 → 设置;页面布局 → 打印标题 → 顶端标题行选第1行
数据是配送行业脱敏数据,照着练就行。<a class="wx_topic_link" topic-id="mwgi15ht-k0uwry" style="color: #576B95 !important;" data-topic="1" data-recommend="">#Excel</a> <a class="wx_topic_link" topic-id="mwgi15hu-y0f0it" style="color: #576B95 !important;" data-topic="1" data-recommend="">#Excel技巧</a> <a class="wx_topic_link" topic-id="mwgi15hu-v2clei" style="color: #576B95 !important;" data-topic="1" data-recommend="">#Excel打印</a> <a class="wx_topic_link" topic-id="mwgi15hu-pt896m" style="color: #576B95 !important;" data-topic="1" data-recommend="">#Excel教程</a> <a class="wx_topic_link" topic-id="mwgi15hu-iu7ki8" style="color: #576B95 !important;" data-topic="1" data-recommend="">#办公技巧</a> <a class="wx_topic_link" topic-id="mwgi15hu-bohxuq" style="color: #576B95 !important;" data-topic="1" data-recommend="">#职场技能</a> <a class="wx_topic_link" topic-id="mwgi15hu-kd6a59" style="color: #576B95 !important;" data-topic="1" data-recommend="">#效率工具</a> <a class="wx_topic_link" topic-id="mwgi15hu-94jw81" style="color: #576B95 !important;" data-topic="1" data-recommend="">#Excel入门</a>















































































