You can also switch to the Page Layout view by clicking on the respective button on the bottom right side in Excel (refer to the above screenshot).

This guide shows you different ways of changing the page orientation in Excel from portrait to landscape. Make it horizontal or vertical.

You don't have to add a header to every Excel worksheet individually when you can group them first. Adding a header (or footer) to an Excel sheet is a simple task using Excel’s Page Layout view.

As an example, the traditional View menu resides on a separate View tab in Excel 2007. This tab houses several view modes, such as Normal, Page Layout and Full Screen.

You can change views in Excel depending on what you're doing and what you want to see. Learn how in this step-by-step tutorial.