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
   207   208   209   210   211   212   213   214   215   216   217