Microsoft Office Tutorials and References
In Depth Information
Printing the Current Worksheet
1. Click the printer icon in the Notification area at the far right of the
Windows taskbar (to the immediate left of the current time) with the
secondary mouse button to open its shortcut menu.
This printer icon displays the ScreenTip 1 document(s) pending for
soand-so . For example, when I’m printing, this message reads 1 document(s)
pending for Greg when I position the mouse pointer over the printer icon.
2. Right-click the printer icon 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).
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 and then click Yes to
confirm you want to cancel the print job.
5. 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.
Understanding and using the print area
Excel includes a special printing feature called
Print Area. Click Print Area ➪ Set Print Area on
the Ribbon’s Page Layout tab or press Alt+PRS
to define any cell selection on a worksheet as
the print area. After you define the print area,
Excel then prints this cell selection anytime you
print the worksheet with the Quick Print button
added to the Quick Access toolbar.
After you define the print area, its cell range
is the only one you can print (regardless of
what other Print What option you select in the
Settings section of the Backstage Print screen).
That is, unless you click the Ignore Print Area
option at the very bottom of the Print What
drop-down list or clear the print area. To clear
the print area (and return to the printing defaults
that Excel establishes in the Print dialog box),
click Print Area ➪ Clear Print Area on the Page
Layout tab or simply press Alt+PRC.
You can also define and clear the print area
from the Sheet tab of the Page Setup dialog
box by clicking the Dialog Box launcher in the
Page Setup group on the Ribbon’s Page Layout
tab. To define the print area from this dialog
box, click the Print Area text box on the Sheet
tab to insert the cursor and then select the cell
range or ranges in the worksheet (remembering
that you can reduce the Page Setup dialog box
to just this text box by clicking the Print Area
Collapse/Expand button). To clear the print area
from this dialog box, select the cell addresses in
the Print Area text box and press the Delete key.