Views on the Worksheet

There is a selection of viewing options in Excel 2016 that alter how your workbook is viewed. These views can be useful for different tasks, especially if you plan to print a spreadsheet. Locate the commands in the bottom-right corner of the Excel window to adjust worksheet views, and pick Regular view, Page layout view, or Page Break view.

  • In Excel, Normal View is the default view for all worksheets.
  • Page Layout view shows how your worksheets are viewed when typed. This view also helps you to add headers and footers.
  • Page Break view allows you to adjust the position of the page breaks, which is particularly useful when you print a lot of Excel details.