Page 295 - Excel 2013 All-in-One For Dummies

Working with the Page Setup Options 277
1. Right-click the printer icon in the notification area at the far right of the Windows taskbar and then select the Open All Active Printers command from its shortcut menu.
This opens the dialog box for the printer with the Excel print job in its queue (as described under the Document Name heading in the list box).
2. Select the Excel print job that you want to cancel in the list box of your printer’s dialog box.
3. Choose Document➪Cancel from the menu bar and then click Yes to confirm you want to cancel the print job.
4. Wait for the print job to disappear from the queue in the printer’s dialog box and then click the Close button to return to Excel.
Working with the Page Setup Options
About the only thing the slightest bit complex in printing a worksheet is fig- uring out how to get the pages right. Fortunately, the command buttons in the Page Setup group on the Ribbon’s Page Layout tab give you a great deal of control over what goes on which page.
There are three groups of buttons on the Page Layout tab that are helpful in getting your page settings exactly as you want them: the Page Setup group, the Scale to Fit group, and the Sheet Options group, all described in upcom- ing sections.
To see the effect of changes you make to the page setup settings in the Worksheet area, put the worksheet into Page Layout view by clicking the Page Layout button on the status bar as you work with the command but- tons in Page Setup, Scale to Fit, and Sheet Options groups on the Page Layout tab.
Using the buttons in the Page Setup group
The Page Setup group of the Page Layout tab contains the following impor- tant command buttons:
✦ Margins: Select one of three preset margins for the report or to set custom margins on the Margins tab of the Page Setup dialog box. (See “Massaging the margins” later in this chapter.)
✦ Orientation: Choose between Portrait and Landscape mode for the printing. (See “Getting the lay of the landscape” later in this chapter.)
✦ Size: Select one of the preset paper sizes or to set a custom size or to change the printing resolution or page number on the Page tab of the Page Layout dialog box.
Book II Chapter 5
Printing Worksheets