Excel 2019 Bible

173

C H A P T E R

7

Printing Your Work

IN THIS CHAPTER

Changing your worksheet view

Adjusting your print settings for better results

Preventing some cells from being printed

Using the Custom Views feature

Creating PDF files

D

espite predictions of the “paperless office,” paper remains an excellent way to carry infor-

mation around and share it with others, particularly if there’s no electricity or Wi-Fi where

you’re going. Some of the worksheets that you develop with Excel will end up as hard-copy

reports, and you’ll want them to look as good as possible. 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 give you a great deal of control over the printed page. These

options are explained in this chapter.

Doing Basic Printing

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. The keyboard shortcut Ctrl+P has the same effect as File ➪

Print. When you use Ctrl+P to show the Backstage view, the Print button has the focus, so you can

simply press Enter to print.

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 to your Quick

Access toolbar.

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 (by using the

Page Layout tab), Excel uses the new settings; otherwise, it uses the following default settings:

■ Prints the active worksheet (or all selected worksheets), including any embedded charts or

objects

■ Prints one copy

Excel® 2019 Bible, First Edition. Michael Alexander, Dick Kusleika and John Walkenbach.
© 2019 John Wiley & Sons, Inc. Published 2019 by John Wiley & Sons, Inc.