|
If you want to use Excel's 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). 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 — but not including comments you add to cells.
When you click the Quick Print button, Excel immediately 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 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 in the process of 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 on-screen), you must open the dialog box for your printer and cancel printing from there:
1. Click the printer icon in the Notification area at the far right of the Windows Vista or XP taskbar (to the left of the current time) with the secondary mouse button to open its shortcut menu.
This printer icon displays the screen tip 1 document(s) pending for so-and-so.
2. Right-click the printer icon and then select the Open 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 heading in the list box).
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 to get rid of it and return to Excel.
 | Printing with the Quick Print button on the Quick Access toolbar is fine if all you want is a single copy of all the information in the current worksheet. If you want more copies, 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. |
Excel provides a number of ways to open the Print dialog box:
- Click Office Button --> Print.
After you make your selections in the Print dialog box, click OK to begin printing.
| 
