学会Excel打印技巧，一年省100张纸，给老板省钱
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel表格，经常要用来打印，<span style="color: black;">倘若</span><span style="color: black;">无</span>提前设置好，浪费纸，达不到<span style="color: black;">咱们</span>想要的效果</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">1、竖向转横向打印</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">例如，下表是<span style="color: black;">机构</span>的一份送货单表格</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/9d7cf31ef85e44cb829d554fff565b27~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984045&x-signature=u9d8MmiwF5j247ec1chiemY7vDs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">倘若</span><span style="color: black;">咱们</span>竖向打印的话，它太长了，放不下，<span style="color: black;">因此</span><span style="color: black;">咱们</span>需要横向的打印，<span style="color: black;">咱们</span><span style="color: black;">选取</span>页面布局，<span style="color: black;">选取</span>纸张方向，<span style="color: black;">选取</span>横向打印</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/1357c034ee994963ba9063d5e3970c45~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984045&x-signature=kEJY%2B4VRHgxEhE41%2FOqctSDDZ4Y%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">2、居中打印</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">倘若</span>只是简单的<span style="color: black;">调节</span>横向打印，有时候表格的位置并不会居中打印</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/eee90adce49a431a848637cbf46b1727~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984045&x-signature=XeJVbD5KxnfOV6Q2jgUUX3HPSgU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">因此</span><span style="color: black;">咱们</span>需要点击页面设置的扩充选项，<span style="color: black;">而后</span>在页边距中，<span style="color: black;">查询</span>水平和垂直选项，进行勾选</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/bf4f2747e0c14f47a8f1faecfa0495f3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984045&x-signature=cAP%2BIuF1%2BcI4ON3f15aAOxjetM0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这般</span>打印出来的表格就居中<span style="color: black;">表示</span>了</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">3、打印在一页中</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">有时候，<span style="color: black;">由于</span><span style="color: black;">咱们</span>的表格宽度太宽，<span style="color: black;">引起</span>有一列单独的打印了出来，<span style="color: black;">无</span>连接在<span style="color: black;">一块</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/94a3478e526442718f31f1be12cdea67~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984045&x-signature=kAb4Z77XKO4IAED9skJqlPe0u1I%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>只需要在页面布局中，设置宽度为1页，它就会自动的帮你缩放，<span style="color: black;">调节</span>到宽度正好是1页的<span style="color: black;">体积</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6844770bb9b74322985a59dfcc3aa225~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984045&x-signature=zxYjEhRWftXymjL5yQms6kgueO0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">倘若</span>你超长了一点点，<span style="color: black;">亦</span><span style="color: black;">能够</span>设置它的高度为1页，这个就<span style="color: black;">能够</span>打印在1页中了</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">4、每页标题打印</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>打印多页表格时，后面每一页的标题数据都<span style="color: black;">无</span>，<span style="color: black;">引起</span>打印出来，不<span style="color: black;">晓得</span>这几列数据<span style="color: black;">表率</span>啥</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/4e4d62774e9143beab4d902c281f10ed~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984045&x-signature=41ZluvgCpKFujqiy%2BG4NIWckmbw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span><span style="color: black;">期盼</span>每一页，都把标题给打印出来 </p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">只需要在页面布局选项上，点击打印标题，<span style="color: black;">而后</span>顶端标题行，<span style="color: black;">咱们</span>直接<span style="color: black;">选取</span>第1行的数据</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c7e8958a2f6d41c39fd31d18b4bab101~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984045&x-signature=AEO5d8hkB5mVQjSgKXFW8dpkZ2A%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这般</span>打印出来的表格，每页都能正常<span style="color: black;">表示</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">关于这几个打印小技巧，你学会了么？动手试试吧！</p>
楼主继续加油啊！外链论坛加油！
页:
[1]