论坛 › 新疆 › 9个Excel打印技巧，动图演示让你一看就懂，保藏备用吧

ikkhksvu 发表于 2024-10-1 20:13:21

9个Excel打印技巧，动图演示让你一看就懂，保藏备用吧

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">想弱弱地问下，有被表格打印<span style="color: black;">熬煎</span>过的<span style="color: black;">朋友</span>吗？无论怎么<span style="color: black;">调节</span>，总是达不到自己想要的样子。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">其实表格的打印很简单，关键是<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>分享9个表格打印的小技巧，让你快速打印出自己满意的表格，动图演示，让你一看就懂，一学就会！</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">想要从零学习Excel，<span style="color: black;">这儿</span>↓↓↓</span></strong></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;">
      <div style="color: black; text-align: left; margin-bottom: 10px;">
            <div style="color: black; text-align: left; margin-bottom: 10px;">
                <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p1.toutiaoimg.com/large/tos-cn-i-jcdsk5yqko/92344094cc9241428c545c589d6654fa" style="width: 50%; margin-bottom: 20px;">
                  <div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">专栏</span></div>
                </div>
                <div style="color: black; text-align: left; margin-bottom: 10px;">
                  <div style="color: black; text-align: left; margin-bottom: 10px;">30天Excel从入门到精通</div>
                  <div style="color: black; text-align: left; margin-bottom: 10px;">作者：Excel从零到一</div>
                  <div style="color: black; text-align: left; margin-bottom: 10px;">
                        <div style="color: black; text-align: left; margin-bottom: 10px;">39.9币</div>
                        <div style="color: black; text-align: left; margin-bottom: 10px;">1,178人已购</div>
                  </div>
                  <div style="color: black; text-align: left; margin-bottom: 10px;">查看</div>
                </div>
            </div>
      </div>
    </div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">1、</span>打印标题行</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">打印标题行，<span style="color: black;">便是</span>让每一张打印纸都<span style="color: black;">表示</span>标题行，这个效果<span style="color: black;">能够</span>直接<span style="color: black;">经过</span>Excel设置来操作</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">点击【页面设置】找到【打印标题】在【顶端标题行】中<span style="color: black;">选取</span>需要打印的标题行，<span style="color: black;">而后</span>点击确定<span style="color: black;">就可</span>，按下快捷键Ctrl+P进入打印预览，就会看到每一页都有标题行了</span></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/8c2c374b728f4a41ba2f2c2757f33825~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727984059&amp;x-signature=s47DQF0LFdxXC5Ypd5umG1%2B%2B19g%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">2、</span>强制分页</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">想要将表格分页打印，<span style="color: black;">非常多</span>人都是一个一个粘贴，其实<span style="color: black;">咱们</span>只需要利用【分页符】就能实现强制分页打印了</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">能够</span>先在【视图】中视图切换为【分页预览】方便观察，随后点击想要分页的【行标号】打开【页面布局】找到【分页符】，直接<span style="color: black;">插进</span>分页符，就能实现强制分页打印了，需要删除的话，点击【删除分页符】<span style="color: black;">就可</span></span></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/df0d0dcd20084e92b87192b4a0b3ba02~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727984059&amp;x-signature=DIQmvnlOHoF8fcM5hsPTkaspkp0%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">3、</span>一页纸打印</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">数据就多了几行，<span style="color: black;">不可</span>打印在一页纸中，<span style="color: black;">怎样</span><span style="color: black;">调节</span>？利用【缩放到一页纸】10秒搞定</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">按下快捷键Ctrl+P进入打印预览，只需在左下角中<span style="color: black;">选取</span>【将工作表<span style="color: black;">调节</span>为一页】就能快速实现一页纸打印了</span></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/790d53476f05408a852797adc7063e0b~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727984059&amp;x-signature=0xa71rtVjhF6FrAxKoXG%2BoP%2BgwE%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">4、</span>不打印图形</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">在<span style="color: black;">这儿</span>说的图形<span style="color: black;">包括</span>：图表，文本框，<span style="color: black;">照片</span>，形状等漂浮在单元格上方的项目</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">按下快捷键Ctrl+A<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></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/c403fba0970e40b895f8bfc1d2281dd8~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727984059&amp;x-signature=gE7jSkKq8jWuZ7SowfcHBOHKPJE%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">5、</span>不打印颜色</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">所说</span>的不打印颜色，是不打印除了黑色之外的颜色！</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">按下【Ctrl+P】进入打印预览，<span style="color: black;">而后</span>点击【工作表】勾选【单色打印】点击确定<span style="color: black;">就可</span>，就会不打印颜色了</span></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/2286a1f6702441f68f994d3fd80b6dc8~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727984059&amp;x-signature=0KZCPxNMuWPU7Gp6uyuTKrshFhM%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">6、</span>不打印错误值</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">咱们</span><span style="color: black;">能够</span>将表格中的错误值打印为空<span style="color: black;">或</span>打印为2个减号！</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><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></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/6a846ea7b38f470585a8953be06bf435~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727984059&amp;x-signature=4rVpZ%2BSZBfQR%2FekCN4yky0kvtek%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">7、</span>添加页码</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">添加页码利用的【页眉/页脚】这2个功能，只需要进入打印预览，<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></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/89d5476c46f34588b8a1988951f0a454~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727984059&amp;x-signature=VlMkrvoVPg4zj9YtMqWS%2BChsWsY%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">8、</span>添加签字区域</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">有的时候<span style="color: black;">咱们</span>想要在表格的最下方的每一页设置一个签字区，<span style="color: black;">例如</span>【审阅】，【审批】之类的，这个就需要用到【自定义页脚】</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">打开【页眉/页脚】的设置界面，点击【自定义页脚】在三个区域中，<span style="color: black;">按照</span>自己的<span style="color: black;">需要</span>输入类目<span style="color: black;">就可</span></span></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/0cc71190c3aa4c54b6e51f7c5c3f5f36~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727984059&amp;x-signature=%2BfXA02srUkINBKCaT4V%2B6du1Q%2BQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">9、</span><span style="color: black;">有些</span>其他操作</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><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></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">标号1：设置打印份数</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">标号2：更换打印机</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">标号3：<span style="color: black;">能够</span>指定打印页数，仅打印<span style="color: black;">例如</span>第五页到第七页</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">标号4：设置打印纸张的方向，横向<span style="color: black;">或</span>纵向</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">标号5：更改打印纸张，A4、A3、A5等</span></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/96f632c5cf454b35a66cdd71be4a9151~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727984059&amp;x-signature=6mhZ5rsBkZgbOwNjV7Oo%2B7%2Bt40A%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 style="color: black;">以上<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></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">我是Excel从零到一，关注我<span style="color: black;">连续</span>分享<span style="color: black;">更加多</span>Excel技巧</span></span></p>

nykek5i 发表于 2024-10-2 22:56:59

真情实感，其含义为认真了、走心了的意思，是如今的饭圈常用语。

b1gc8v 发表于 2024-10-29 11:47:10

你的话深深触动了我，仿佛说出了我心里的声音。

4lqedz 发表于 7 天前

你的见解真是独到，让我受益匪浅。

1fy07h 发表于 3 天前

感谢楼主分享，祝愿外链论坛越办越好！

查看完整版本: 9个Excel打印技巧，动图演示让你一看就懂，保藏备用吧