Excel 简明教程

Adjust Margins in Excel 2010

Margins

页边距是打印页边、顶部和底部的未打印区域。MS Excel 中所有打印页都具有相同的页边距。您无法为不同的页面指定不同的页边距。

Margins are the unprinted areas along the sides, top, and bottom of a printed page. All printed pages in MS Excel have the same margins. You can’t specify different margins for different pages.

您可以通过以下方式设置页边距。

You can set margins by various ways as explained below.

  1. Choose Page Layout » Page Setup » Margins drop-down list, you can select Normal, Wide, Narrow, or the custom Setting.

margin from page layout
  1. These options are also available when you choose File » Print.

margin from file menu

如果以上设置均无法解决问题,请选择自定义边距以显示“页面设置”对话框的“边距”选项卡,如下所示。

If none of these settings does the job, choose Custom Margins to display the Margins tab of the Page Setup dialog box, as shown below.

margin setup

Center on Page

默认情况下,Excel 会将打印页对齐在顶部和左侧边距。如果您希望输出水平或垂直居中,请在“页面设置”对话框的“边距”选项卡的“分页居中”区域选择相应的复选框,如以上屏幕截图所示。

By default, Excel aligns the printed page at the top and left margins. If you want the output to be centered vertically or horizontally, select the appropriate check box in the Center on Page section of the Margins tab as shown in the above screenshot.