Chapter 7. Printing Annoyances
Sooner or later, most worksheets get printedâproviding tangible evidence of your hard work, as well as the real location of the paperless office (just down the block from Shangri-La). So itâs important that the printed output do your efforts justice. If you spend hours or even days entering data and building elaborate workbooks, you should be able to print out that data without hassles. In this chapter, Iâll look at the one class of annoyances that dogs all Excel users: controlling what prints. It might be multiple workbooks, a single worksheet, or even a small selection (as tiny as one cell). Then weâll move on to annoyances you bang into when you request a special layout or try to control where content appears on a skein of printed pages. Along the way, youâll discover how to control gridlines, page numbers, report titles, and so on. Finally, youâll learn how to pick a printer, dictate output quality, check the status of a print job, and more.
BASIC PRINTING ANNOYANCES
SQUEEZE THAT ENTIRE WORKSHEET ONTO ONE PAGE
The Annoyance:
My worksheet prints with lots of its columns or rows scattered onto a second page. This makes it hard to read the worksheet (see a print preview in Figure 7-1), and it wastes paperâI really need it to fit onto a single sheet. How can I manage that?
Figure 7-1. Without intervention, critical information will be shunted ...
Get Excel Annoyances now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.