Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Learn Microsoft Office 2019

You're reading from   Learn Microsoft Office 2019 A comprehensive guide to getting started with Word, PowerPoint, Excel, Access, and Outlook

Arrow left icon
Product type Paperback
Published in May 2020
Publisher Packt
ISBN-13 9781839217258
Length 794 pages
Edition 1st Edition
Tools
Arrow right icon
Author (1):
Arrow left icon
Linda Foulkes Linda Foulkes
Author Profile Icon Linda Foulkes
Linda Foulkes
Arrow right icon
View More author details
Toc

Table of Contents (26) Chapters Close

Preface 1. Section 1: Word
2. Exploring the Interface and Formatting Elements FREE CHAPTER 3. Creating Lists and Constructing Advanced Tables 4. Creating Professional Documents 5. Versions, Restrictions, and Comparisons 6. Section 2: PowerPoint
7. The PowerPoint Interface and Presentation Options 8. Formatting Slides, Tables, Charts, and Graphic Elements 9. Photo Albums, Sections, and Show Tools 10. Section 3: Excel
11. Formatting, Manipulating, and Presenting Data Visually 12. Applying Formulas and Functions 13. Analyzing and Organizing Data 14. Section 4: Common Tasks
15. Exporting and Optimizing Files and the Browser View 16. Sharing and Protecting Files 17. Section 5: Access
18. Database Organization and Setting Relationships 19. Building Forms and Report Design 20. Constructing Queries to Analyze Data 21. Section 6: Outlook
22. Creating and Attaching Item Content 23. Managing Mail and Contacts 24. Calendar Objects, Tasks, Notes, and Journal Entries 25. Other Books You May Enjoy

Setting print options

In this section, you will learn how to print a single worksheet, selected worksheets, and a workbook; how to add and modify header and footer content and other options.

Before we delve into the actual printing of worksheets and workbooks, let's learn about the views that exist in Excel 2019, and other important tasks we need to know before looking at the printing aspects, as follows:

  • Normal view: This is the default view you see when opening a workbook in the Excel environment. This is the view in which you would create your data. The different views are displayed on the View tab, or accessible via the status bar, as illustrated in the following screenshot:
  • Page Layout view: Viewing your worksheet in Page Layout view displays the worksheet, as it would look when printed. It also displays all headers and footers in the document. Headers and footers...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €18.99/month. Cancel anytime