Chapter 4
Printing Worksheet Reports
IN THIS CHAPTER
Previewing pages in the worksheet and Backstage view
Using Page Break Preview to adjust the paging
Adding readymade and custom headers and footers to a report
Adjusting various page and print settings
Printing all or portions of a workbook
You probably won't have to print your worksheets very often, but when you do, you'll want to make your printed Excel reports easy to read and well organized. The exercises in this chapter give you a chance to practice printing many types of worksheet reports using Excel’s Page Layout view, Page Break Preview, headers and footers, and Print Titles features. Don’t worry if you don’t have access to a printer while completing these exercises: In almost all cases, you can use Excel’s Print Preview feature in the Backstage view's Print panel to get an idea of how the report will appear on the printed page.
Previewing Pages in the Worksheet and Backstage View
In the regular worksheet view, Page Layout ...
Get Excel Workbook For Dummies, 2nd Edition 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.
