In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

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 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).

In the Workbook Views section of the View Ribbon, click the button for Page Layout to see how many printed pages your spreadsheet will take.

Quick Take: Excel 2004 for Mac boasts a new Page Layout view. This is essentially a page preview mode that lets you edit and manipulate objects, including headers and footers, as they appear on ...

Select the "View" tab, and click the "Page Break View" button on the Excel ribbon. Excel shows how your worksheet divides into pages when printed with the current settings.