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

276 Quick Printing the Worksheet
Excel indicates the number of pages in a report at the bottom left of the Print Preview area. If your report has more than one page, view pages that follow by clicking the Next Page button. To review a page you’ve already seen, back up a page by clicking the Previous Page button immediately below it. (The Previous Page button is grayed out if you’re on the first page.) You can also advance to a particular page in the report by typing its page number into the text box to the immediate right of the Previous Page button that shows the current page and then pressing the Enter key.
If you want to display the current margin settings for the report in the print preview area, click the Show Margins button at the bottom of the Print screen to the immediate left of the Zoom to Page button. After the margins are displayed, you can then manually manipulate them by dragging them to new positions. (See “Massaging the margins” later in this chapter for details.)
When you finish previewing the report, you can print the spreadsheet report by clicking the Print button in the Print screen or you can exit the Backstage view and return to the worksheet by clicking the Back button at the very top of the File menu along the left side of the screen.
Quick Printing the Worksheet
As long as you want to use Excel’s default print settings to print all the cells in the current worksheet, printing in Excel 2013 is a breeze. Simply add the Quick Print button to the Quick Access toolbar by clicking the Customize Quick Access Toolbar button and then choosing the Quick Print item from its drop-down menu.
After adding the Quick Print button to the Quick Access toolbar, you can use this button to print a single copy of all the information in the current worksheet, including any charts and graphics, everything but the comments you’ve add to cells.
When you click the Quick Print button, Excel routes the print job to the Windows print queue, which acts like a middleman and sends the job to the printer. While Excel sends the print job to the print queue, Excel displays a Printing dialog box to inform you of its progress (displaying such updates as Printing Page 2 of 3). After this dialog box disappears, you are free to go back to work in Excel. To stop the printing while the job is still being sent to the print queue, click the Cancel button in the Printing dialog box.
If you don’t realize that you want to cancel the print job until after Excel finishes shipping it to the print queue (that is, while the Printing dialog box appears onscreen), you must take these steps: