Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

If you can use the default print settings to print all the cells in the current worksheet, printing in Excel 2007 is a breeze. Simply add the Quick Print button to the Quick Access toolbar (by clicking the Customize Quick Access Toolbar button and then clicking Quick Print on its drop-down menu). If you need to change common settings however, such as selecting a different printer or specifying a range of pages to print rather than the entire worksheet, use the Print dialog box (press Ctrl+P).

Quick printing a worksheet

After adding the Quick Print button to the Quick Access toolbar, you can click this button to print a single copy of all the information in the current worksheet, including any charts and graphics (but not including comments you add to cells), to the default printer.

When you click the Quick Print button, Excel routes the print job to the Windows print queue, which acts like a middleman to send 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.

Printing from the Print dialog box

Printing with the Quick Print button is fine if all you want is a single copy of all the information in the current worksheet. If you want more copies, or more or less data (such as all the worksheets in the workbook or just a cell selection within a particular worksheet), then you need to print from the Print dialog box.

Use the Print dialog box to change common print settings.
Use the Print dialog box to change common print settings.

Excel provides several ways to open the Print dialog box:

  • Press Ctrl+P.

  • Click the Office button and choose Print.

  • Press Alt+FP.

After you open the Print dialog box, change any settings as needed and click OK to begin printing.

Canceling a print job

If you need to stop the printing while a print job is in the process of being sent to the print queue, click the Cancel button in the Printing dialog box. If this dialog box has already vanished (after Excel finishes shipping to the print queue), you must open the dialog box for your printer and cancel printing from there:

  1. Right-click the printer icon in the Notification area at the far right of the Windows Vista or XP taskbar to open its shortcut menu.

  2. Select Open Active Printers from the shortcut menu.

    This opens the dialog box for the printer with the Excel print job in its queue.

  3. Select the Excel print job that you want to cancel in the list box of your printer’s dialog box.

  4. Choose Document→Cancel from the menu bar.

  5. Wait for the print job to disappear from the queue in the printer’s dialog box and then click the Close button.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: