Excel 2013 All-in-One For Dummies
Book image
Explore Book Buy On Amazon

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:

  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.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is President of Mind Over Media and a highly skilled instructor. He has been writing computer books for more than 20 years, and his long list of bestsellers includes all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies.

This article can be found in the category: