Excel 2010 Bible

Part I: Getting Started with Excel

178

TABLE 9.1 (continued)

Setting

Print Settings

Screen

Page Layout

Tab of Ribbon

Page Setup Dialog

Box

Specify page order X

Specify black-and-white output X

Specify how to print error cells X

Launch dialog box for printer-specific settings X X

Choosing your printer .............................................................................................

To switch to a different printer, choose File ➪ Print, and use the drop-down control in the Printer

section to select a different installed printer.

Note

To adjust printer settings, click the Printer Properties link to display a property box for the selected printer. The

exact dialog box that you see depends on the printer. The Properties dialog box lets you adjust printer-specific

settings, such as the print quality and the paper source. In most cases, you won’t have to change any of these

settings, but if you’re having print-related problems, you may want to check the settings. n

Specifying what you want to print ...........................................................................

Sometimes you may want to print only a part of the worksheet rather than the entire active area.

Or you may want to reprint selected pages of a report without printing all the pages. Choose

File ➪ Print, and use the controls in the Settings section to specify what to print.

You have several options:

l Active Sheets: Prints the active sheet or sheets that you selected. (This option is the

default.) You can select multiple sheets to print by pressing Ctrl and clicking the sheet

tabs. If you select multiple sheets, Excel begins printing each sheet on a new page.

l (^) Entire Workbook: Prints the entire workbook, including chart sheets.
l Selection: Prints only the range that you selected before choosing File ➪ Print.
l (^) Selected Table: Appears only if the cell pointer is within a table (created with
Insert ➪ Tables ➪ Table) when the Print Setting screen is displayed. If selected, only the
table will be printed.
Tip
You can also choose Page Layout ➪ Page Setup ➪ Print Area ➪ Set Print Area to specify the range or ranges to
print. Before you choose this command, select the range or ranges that you want to print. To clear the print
area, choose Page Layout ➪ Page Setup ➪ Print Area ➪ Clear Print Area. To override the print area, select the
Ignore Print Areas check box in the list of Print What options. n