Page 198 - Excel 2007 Bible

14_044039 ch10.qxp 11/21/06 11:03 AM Page 155
Printing Your Work
espite predications of the “paperless office,” reports printed on paper
remain commonplace, and they will be around for a long time. Many of IN THIS CHAPTER
Dthe worksheets that you develop with Excel can easily serve as printed One-click printing
reports. You’ll find that printing from Excel is quite easy and that you can gener-
ate attractive, well-formatted reports with minimal effort. In addition, Excel has Changing your worksheet view
many options that provide you with a great deal of control over the printed page
so that you can make your printed reports even better. These options are Adjusting your print settings for
explained in this chapter. better results
Preventing some cells from being
Printing with One Click printed
Using Custom Views
If you simply want to print a copy of a worksheet with no fuss and bother, use
Excel’s Quick Print option. One way to access this command is to choose Office ➪
Print ➪ Quick Print. But if you like the idea of one-click printing, take a few sec-
onds to add a new button to your Quick Access Toolbar (QAT):
1. Click the downward-point arrow to the right of the QAT, which
displays a menu.
2. Choose Quick Print from the menu. Excel adds the Quick Print icon
to your QAT.
Clicking the Quick Print button prints the current worksheet on the currently
selected printer, using the default print settings. If you’ve changed any of the
default print settings, Excel uses the new settings; otherwise, it uses the following
default settings:
n Prints the active worksheet (or all selected worksheets), including any
embedded charts or objects.
n Prints one copy.
n Prints the entire worksheet.

155