Excel 简明教程

Printing Worksheets in Excel 2010

Quick Print

如果您想打印一张未调整版式的电子表格副本，请使用“快速打印”选项。我们可以通过两种方式使用此选项。

If you want to print a copy of a worksheet with no layout adjustment, use the Quick Print option. There are two ways in which we can use this option.

  1. Choose File » Print (which displays the Print pane), and then click the Print button.

  2. Press Ctrl+P and then click the Print button (or press Enter).

printing worksheet

Adjusting Common Page Setup Settings

您可以通过不同方式调整页面设置对话框中可用的打印设置，如下所述。页面设置选项包括页面方向、页面大小、页面边距等。

You can adjust the print settings available in the Page setup dialogue in different ways as discussed below. Page setup options include Page orientation, Page Size, Page Margins, etc.

  1. The Print screen in Backstage View, displayed when you choose File » Print.

  2. The Page Layout tab of the Ribbon.

Choosing Your Printer

要切换到不同的打印机，请选择 File » Print 并使用“打印机”部分中的下拉控件选择任何其他已安装的打印机。

To switch to a different printer, choose File » Print and use the drop-down control in the Printer section to select any other installed printer.

setting printer

Specifying What You Want to Print

有时，您可能只想打印电子表格的一部分，而不是整个活动区域。选择 File » Print 并使用“设置”部分中的控件来指定要打印的内容。

Sometimes you may want to print only a part of the worksheet rather than the entire active area. Choose File » Print and use the controls in the Settings section to specify what to print.

  1. Active Sheets − Prints the active sheet or sheets that you selected.

  2. Entire Workbook − Prints the entire workbook, including chart sheets.

  3. Selection − Prints only the range that you selected before choosing File » Print.

set what to print