Excel® 2007 Bible

Chapter 10. Printing Your Work

<feature><title>In This Chapter</title>

• One-click printing

• Changing your worksheet view

• Adjusting your print settings for better results

• Preventing some cells from being printed

• Using Custom Views

</feature>

Despite predications of the “paperless office,” reports printed on paper remain commonplace, and they will be around for a long time. Many of the worksheets that you develop with Excel can easily serve as printed reports. You’ll find that printing from Excel is quite easy and that you can generate attractive, well-formatted reports with minimal effort. In addition, Excel has 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 explained in this chapter.

Printing with One Click

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 seconds 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 ...