Page 212 - Excel 2007 Bible
P. 212
14_044039 ch10.qxp 11/21/06 11:03 AM Page 169
Printing Your Work
Choosing your printer
The Printer section of the Print dialog box enables you to choose which printer you want to use as well as to
access the settings that are specific to the selected printer.
Make sure that you have selected the correct printer (applicable only if you have access to more than one
printer). You select the printer from the Name drop-down list. This section of the dialog box also lists infor-
mation about the selected printer, such as its status and where it’s connected.
If you want to adjust the printer’s settings, click the Properties button to display a property box
NOTE
NOTE
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.
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. You can make both of these
types of selections in the Print dialog box, too (see Figure 10.8).
The Print What section of the Print dialog box lets you specify what to print. You have several options: 10
n Selection: Prints only the range that you selected before choosing Office ➪ Print.
n Active Sheet(s): 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.
n Entire Workbook: Prints the entire workbook, including chart sheets.
n Table: Enabled only if the cell pointer is within a table when the Print dialog box 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
TIP
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 Print dialog box.
If your printed output uses multiple pages, you can select which pages to print by indicating the number of
the first and last pages to print in the Print Range section of the Print dialog box. You can either use the
spinner controls or type the page numbers in the edit boxes.
Printing multiple copies of a report
The Copies section of the Print dialog box lets you specify the number of copies to print. Simply enter the
number of copies you want and then click OK to print them.
TIP If you’re printing multiple copies of a report, make certain that the Collate check box is
TIP
selected. If you choose this option, Excel prints the pages in order for each set of output. If
you’re printing only one page, Excel ignores the Collate setting.
169