Using the View Tab

Excel offers three workbooks views, Normal, Page Layout and Page Break Preview.

Using Normal View

1. On the View tab, in the Workbook Views group, click Normal.

Note: if you switch to another view and return to Normal view, Excel displays page breaks. Close and reopen the Excel file to hide these page breaks. To always hide page breaks for this worksheet, click File, Options, Advanced, scroll down to Display options for this worksheet and uncheck Show page breaks. 

Using Full Screen View

To view more data on the screen, you can temporarily switch to full-screen view. Full-screen view hides the Microsoft Office Fluent user interface Ribbon, the formula bar, and the status bar. To have access to the hidden elements again, you have to return to normal screen view.

• To switch to the full-screen view, on the View tab, in the Workbook Views group, click Full Screen. 
• To return to normal screen view, right-click anywhere in the worksheet, and then click Close Full Screen or press ESC in the keyboard.

Note: The Full-screen option is not available in Excel 2013 and later versions. However, you can always hide the ribbon, tabs, or commands, to maximize the screen space in Excel.  

Using Page Layout View

Use Page Layout view to see where pages begin and end, and to add headers and footers.

1. On the View tab, in the Workbook Views group, click Page Layout.

Page Break Preview

Page Break Preview gives you a nice overview of where pages break when you print the document. Use this view to easily click and drag page breaks.

1. On the View tab, in the Workbook Views group, click Page Break Preview.
   

Note: 

• Click and drag the page breaks to fit all the information on one page. Be careful, Excel doesn't warn you when your printout becomes unreadable. 
• By default, Excel prints down, then over. In other words, it prints all the rows for the first set of columns. 
• Next, it prints all the rows for the next set of columns, etc. (take a look at the page numbers in the picture above to get the idea). 
• To switch to Print over, then down, click File, Print, Page Setup, on the Sheet tab, under Page order, click Over, then down.