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...