excel打印分页打印技巧_Excel打印技巧视频

excel打印分页打印技巧

Someone asked me for help with an Excel printing question recently – how to make the columns all fit on one printed page. Most of us don't print our Excel sheets too often, so it's easy to forget those Excel printing tips! Videos and tips below show a few things you can do to make Excel printing easier.

最近有人问我有关Excel打印问题的帮助-如何使所有列都适合一个打印页面。 我们大多数人不会经常打印Excel工作表，因此很容易忘记这些Excel打印技巧！ 下面的视频和提示显示了一些可以使Excel打印更轻松的操作。

Excel打印提示 (Excel Printing Tips)

This is a collection of some of my favourite Excel printing tips.

这是一些我最喜欢的Excel打印提示的集合。

To see the written steps for these videos, and more Excel printing tips, go to my Contextures website.

若要查看这些视频的书面步骤以及更多Excel打印提示， 请访问我的Contextures网站。

在一张纸上适合列 (Fit Columns on One Sheet)

This video shows how to make all the columns fit on one printed page. You'll also see how to show the column headings at the top of each printed page.

该视频显示了如何使所有列适合一个打印页面。 您还将看到如何在每个打印页面的顶部显示列标题。

演示地址

打印所有图纸 (Print All the Sheets)

Instead of printing sheets one at a time, watch this short video to see how to print all the sheets in an Excel file at once.

观看这段简短的视频，而不是一次打印一张纸，以了解如何一次在Excel文件中打印所有纸。

Be sure to watch to the very end, to see an important step! Without that step, you could accidentally overwrite the worksheet data

一定要注意到最后 ，看到重要的一步！ 没有该步骤，您可能会意外覆盖工作表数据

演示地址

仅打印命名的Excel表 (Print a Named Excel Table Only)

When you're working with a named Excel table, this video shows a quick way to print just the table, without all the other stuff that's on the worksheet.

当您使用命名的Excel表时 ，此视频显示了一种仅打印表的快速方法，而没有工作表上的所有其他内容。

演示地址

打印前显示Excel消息 (Show Excel Message Before Printing)

And if you want to get really fancy with your Excel printing, use a bit of programming!

而且，如果您想真正使用Excel打印，请使用一些编程！

This video explains how to show a message before printing, if key information is missing from the worksheet. There are more details in this article: Collect Data from Users

如果工作表中缺少关键信息，该视频说明了如何在打印前显示消息。 本文中有更多详细信息： 从用户收集数据

演示地址

更多Excel打印提示 (More Excel Printing Tips)

To see the written steps for these videos, and more Excel printing tips, go to my Contextures website.

要查看这些视频的书面步骤以及更多Excel打印提示， 请访问我的Contextures网站。

There are instructions for printing the gridlines,  and details on how to get rid of that "Page 1" text that you see sometimes, in the middle of a worksheet.

在工作表中间，有打印网格线的说明，以及有关如何消除有时会看到的“第1页”文本的详细信息。

翻译自: https://contexturesblog.com/archives/2019/11/14/excel-printing-tips-videos/

excel打印分页打印技巧