Excel 2010 Bible

171

CHAPTER

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

D

espite 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 con-
trol 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 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 from the
drop-down list. Excel adds the Quick Print icon (looks like a desktop
printer) to your Quick Access toolbar.

Clicking the Quick Print button prints the current worksheet on the cur-
rently selected printer, using the default print settings. If you’ve changed any