Setting print options in Microsoft Excel 2019

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 viewThis 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:

ms office 374

  • Page Layout viewViewing 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 Normal view 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:

ms office 718

  • Page Break viewThis 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:

ms office 767

Now that you have had an introduction to the different workbookviews, let’s learn to insert page breaks on a worksheet in the nexttopic.

Leave a Comment