In this section, you will learn how to print a single worksheet,selected worksheets, and a workbook; how to add and modify header andfooter 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 otherimportant tasks we need to know before looking at the printing aspects,as follows:
- Normal view: This is the default view you seewhen opening a workbook in the Excel environment. This is the view inwhich you would create your data. The different views are displayed onthe View tab, oraccessible via the status bar, as illustrated in the followingscreenshot:
- Page Layout view: Viewing your worksheetin Page Layoutview displays the worksheet, as it would look when printed. Italso displays all headers and footers in the document. Headers andfooters are editable in this view. When changing a view from
Normalview to any other view and then backto Normal view again, you will noticea slight change in the worksheet. Vertical and horizontal dashed linesappear on your worksheet, and these indicate the page breaks in theworksheet. Page breaks are also visible on all the other views to guideyou when customizing the layout prior to printing. An example of Normal view can be seen in the followingscreenshot:
- Page Break view: This view gives you theopportunity to view horizontal and vertical page breaks in the document,and allows you to adjust these page breaks to fit information onto aworksheet. It also identifies each page number by placing a watermark oneach page in the workbook to guide you, as illustrated in the followingscreenshot:
Now that you have had an introduction to the different workbookviews, let’s learn to insert page breaks on a worksheet in the nexttopic.