Click the File tab, and then click Print to display the Print screen in Backstage view, shown in Figure 11-13. Click the big Print button at the top of the screen to send the current worksheet immediately to the printer. But there are other things you might want to do first.
Figure 11-13. Click the File tab on the ribbon, and then click Print to tell Excel what you want to print and how many copies you want.
Setting Printer Driver Options
Occasionally while working in Excel 2010, you might need to set options that only your printer driver provides. For example, you might need to switch from automatic to manual paper feed or from one paper tray to another. You can do this by clicking either the Printer Properties link below the Printer button on the File tab’s Print screen (refer to Figure 11-16) or the Options button in the Page Setup dialog box (refer to Figure 11-11) to open the Properties dialog box for the selected printer.
The File tab’s Print screen contains these options for specifying what, where, and how you want Excel 2010 to print. Each large rectangle you see in Figure 11-13 is actually a menu, and collectively the following options are represented:
Print Click the big Print button when you’re ready to send your job to the printer.
Copies Enter the number of copies you want. You can specify up to 32,767 copies.
Printer Displays the name of your default printer. To use a different printer, click to display a list of available printers, and then select the printer you want to use.
Sheet The default Print Active Sheet option prints the active worksheet (or a set of grouped worksheets). Print Entire Workbook, predictably, prints all the sheets in the workbook, and Print Selection prints only the selected cells. If you have defined a print area on any or all of the specified worksheets, Excel prints only those ranges. For more information about selecting a group of worksheets, see Editing Multiple Worksheets on page 255.
Ignore Print Area If you have defined print areas on the worksheet or worksheets specified for printing, select this item at the bottom of the Print Sheets menu box to disregard them. It is a toggle; click it again to turn it off.
Pages Specify an exact page or range of pages to print in the active worksheet(s).
Collated If your worksheet is more than one page long and you plan to print multiple copies, Excel collates the copies for you. For example, instead of printing five copies of page 1 followed by five copies of page 2, Excel prints page 1 and page 2 together, prints the next set, and so on. Collated copies are more convenient but might take longer to print. Or you can choose Uncollated.
Orientation Choose Portrait or Landscape.
Page Size Select the size of the paper you’re using. Letter 8 ½ x 11in is the default. Click More Paper Sizes to display the Page Setup dialog box.
Margins Select Normal, Wide, or Narrow or Last Custom Setting, which offers the last margin settings you specified. Click Custom Margins to display the Page Setup dialog box.
Scaling Shrink your worksheet to fit your output paper. Choose Fit Sheet On One Page, Fit All Columns On One Page, Fit All Rows On One Page, or the default No Scaling. For more precise control, click Custom Scaling Options to display the Page Setup dialog box.
Printing Immediately
Click the Quick Print button on the Quick Access Toolbar to print the active sheet immediately using the current settings. If the Quick Print button is not visible, click the arrow to the right of the Quick Access Toolbar to display the Customize Quick Access Toolbar menu, and click Quick Print to add the button to the toolbar.
For more information, see Using the Quick Access Toolbar on page 34.