Excel gives you several ways to print a worksheet:
When you select File, Print or press Ctrl+P, Excel displays the Print dialog box. This dialog box enables you to print some or all the pages within a worksheet, selected data, the active worksheet, or the entire workbook. You can also specify the number of copies of the printout, and you can collate pages when you print multiple copies of a multipage worksheet. You can even print a worksheet to another file. If your printer options are already set up for printing the document, you can simply click the Print button on the Standard toolbar. Excel doesn't display the Print dialog box and prints the worksheet immediately. This printing method is useful for quick printing, but you can't change any options.
Checking Your PrinterBefore you use your printer with Excel, it's advisable to check the Printer Setup options. You often need to provide more details about your printer so Excel can use the options and capabilities that are available with your particular printer. For most printers, the Printer Setup options let you select the paper size and paper type. You can choose the paper feed type: cut-sheet (single sheets of paper) or banner (continuous form paper). You can also select from three types of print quality:
You can try your hand at checking the printer setup options in the next exercise. To Do: Check the Printer Setup Options
Printing Your WorksheetsIf you want to print one worksheet just the way it is without changing any print options, simply click the Print button on the Standard toolbar. But suppose you want to print more than one worksheet. No problemyou just need to tell Excel which worksheets you want to print. You can print contiguous or noncontiguous worksheets. Contiguous worksheets Worksheets that are next to each other in the workbook, without any worksheet that you don't want in between them. Noncontiguous worksheets Worksheets that are separated by several worksheets that you do not want. To select worksheets, you click on the worksheet tabs. An active worksheet's tab is white, whereas the tab of an inactive worksheet is gray. You learn how to print contiguous and noncontiguous worksheets in the upcoming exercise. To Do: Print Worksheets
Printing a RangeYou can choose which pages you want to print in the Print Range area in the Print dialog box. You have two choices: All or Pages. Printing all the pages in your active sheet is the default print range setting. However, you can print specific pages by choosing the Page(s) option and entering the page numbers in the From and To boxes. For example, if you type 1 in the From box and 3 in the To box, Excel prints pages 1 through 3. The next exercise demonstrates how to print only page 2. To Do: Print Ranges
Printing a SelectionWhat if you want to print a portion of the worksheet? You can do just that by selecting the cells , rows, and/or columns you want to print. Then click File, Print. In the Print dialog box, in the Print What section, choose Selection. This option prints only the portion of the worksheet you selected. Printing the Entire WorkbookYou can print the entire workbook with all its worksheets in one fell swoop. To do so, click File, Print. In the Print dialog box, in the Print What section, choose Entire Workbook. This option prints the whole workbook.
Faxing a WorkbookYou can fax a workbook if you have fax software and hardware installed and set up on your computer. To send a workbook as a fax, choose File, Print. In the Name drop-down list, select the fax service that appears in the list. Select the fax options you want and click OK. Canceling PrintingYou can cancel a print job either before it prints or while it prints. Canceling a print job does not work for workbooks such as the one in the exercises in this hour , unless you are on a network or have other workbooks lined up to print. Excel prints a small worksheet faster than you can cancel it. While a worksheet is printing, Windows displays a Printer icon at the right end of the Windows taskbar. To stop a worksheet from printing, double-click the printer icon to display the Print Queue dialog box (see Figure 7.9). Click the document name and select Document, Cancel from the menu bar in the dialog box to cancel the print job. Click the Close button to close the dialog box. Figure 7.9. Canceling printing in the Print Queue dialog box.
|