Excel® 2010 Bible

Chapter 9. Printing Your Work

IN THIS CHAPTER

One-click printing

Changing your worksheet view

Adjusting your print settings for better results

Preventing some cells from being printed

Using Custom Views

Despite predictions of the "paperless office," reports printed on paper remain commonplace, and they will be around for a long time. Many worksheets that you develop with Excel can probably 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.

9.1. Printing with One Click

If you want to print a copy of a worksheet with no fuss and bother, use the Quick Print option. One way to access this command is to choose File Print (which displays the Print pane of Backstage View), and then click the Print button.

Issuing that command with a mouse takes three clicks, though. A slightly more efficient method is to press Ctrl+P and then click the Print button (or press Enter).

But if you like the idea of one-click printing, take a few seconds to add a new button to your Quick Access toolbar: Click the downward-pointing arrow on the right of the Quick Access toolbar and then choose Quick Print ...