如果您在Excel中创建了一个小工作表,您可能希望在打印时将其置于页面中心。默认情况下,它将打印在页面的左上角。对于非常小的数据集,这可能会降低演示文稿的有效性。
有一种简单的方法可以使打印页面上的数据居中。您可以将数据水平、垂直或两者居中。
要查看打印时工作表的显示方式,请单击文件(File),然后单击打印(Print)。您将在最右侧获得文档的预览。
预览上面的示例工作表时,您可以看到它位于页面的左上角。这就是它的打印方式。
要使打印页面上的数据居中,请单击页面布局(Page Layout)选项卡。然后,单击“页面布局”选项卡的“(Page Layout)页面设置(Page Setup)”部分右下角的箭头按钮。
显示页面设置(Page Setup)对话框。单击边距(Margins)选项卡。如果您希望信息在页面边距之间从左到右居中,请在页面(Center on page)标题居中下选中水平复选框。(Horizontally)如果您希望信息在页面边距之间从上到下居中,请选中垂直复选框。(Vertically)如果您希望数据在页面中水平和垂直居中,请选中这两个复选框。(Select)
单击(Click)Preview Preview按钮,现在您将看到页面居中的数据。您还可以更改页面方向,它将保持居中。
页面上的数据居中仅对当前选定的工作表有效。因此(Therefore),即使在Sheet 2上有一整页数据,您也可以在(Sheet 2)Sheet 1上将较小的数据集居中,而不会影响其他工作表。
此外,如果您有一张包含大量数据的表格,并且您只想打印出表格的一部分,但仍希望它居中,那么您可以通过首先选择要打印的数据来做到这一点。选择数据后,转到File Print ,您将在(File Print)Settings下方看到一个下拉菜单。
您可以选择打印活动工作表、打印整个工作簿或在当前选择上打印。这真的很方便,因为您可能有一个巨大的工作表,但只需要打印一个摘要图或图表。享受!
Center Your Worksheet Data in Excel for Printing
If you have created a small worksheet in Εxcel, уou may want to center it on the page when you print it. By default, it will print in the uрper, left corner of the page. For a very small set of datа, this can detract from thе effectivеness of yoυr presentation.
There is an easy way to center the data on the printed page. You can center the data horizontally, vertically, or both.
To see how your worksheet will display when printed, click on File and then Print. You’ll get a preview of the document at the far right.
When the sample worksheet above is previewed, you can see that it is placed in the upper, left corner of the page. This is how it will print.
To center the data on the printed page, click the Page Layout tab. Then, click the arrow button in the lower, right corner of the Page Setup section of the Page Layout tab.
The Page Setup dialog box displays. Click the Margins tab. Under the Center on page heading, select the Horizontally checkbox if you want the information centered left-to-right between the margins of the page. Select the Vertically check box if you want the information centered top-to-bottom between the margins of the page. Select both checkboxes if you want the data centered in the page both horizontally and vertically.
Click the Preview Preview button and now you will see the data centered on the page. You can also change the page orientation and it will remain centered.
Centering data on a page is effective only for the currently selected sheet. Therefore, even if you have a full page of data on Sheet 2, you can center the smaller set of data on Sheet 1 without affecting other sheets.
Also, if you have a sheet with a lot of data on it and you only want to print out one section of the sheet, but still want it centered, then you can do that by first selecting the data you want to print. Once you have the data selected, go to File Print and you’ll see a dropdown right below Settings.
You can choose to print the active sheets, print the entire workbook or print on the current selection. This is really handy as you might have a huge worksheet, but only need to print a summary graph or chart. Enjoy!