Click the button for the view you want to use in the Workbook Views group.
Normal View: This is the default Excel view, and the one you’ll usually want to use when creating and editing workbooks. Row and column headers are displayed.
Page Break Preview View: This view shows you where the page breaks will occur if you print the worksheet. This is helpful for making sure your data is laid out correctly to appear on the desired page(s).
Page Layout View: Use this view to fine-tune a worksheet before printing, especially if it contains charts. You can edit the worksheet like it’s in Normal view, but you can also see the rulers, change page orientation, work with headers, footers and margins, and hide or display row or column headers.
You can click the button for the view you want to use in the status bar of the workbook window.