Working in Excel 2007’s Page Layout View
Excel 2007’s new Page Layout gives you an instant view of how the printed Excel page will look. You activate this view by clicking the Page Layout View button (the center one) to the immediate left of the Zoom slider on the Status bar or the Page Layout View command button on the View tab of the Ribbon.
When you switch to Page Layout view, Excel adds horizontal and vertical rulers to the column letter and row number headings. In the Worksheet area, this view shows the margins for each printed page, with any headers and footers defined for the report, along with the breaks between each page.
To see all the pages required to print the active worksheet, drag the slider button in the Zoom slider on the Status bar to the left until you decrease the screen magnification sufficiently to display all the pages of data.
Excel displays rulers using the default units for your computer (inches on a U.S. computer and centimeters on a European machine). To change the ruler units, follow these steps:
Click the Office button and then click the Excel Options button.
The Excel Options dialog box appears.
Click the Advanced tab and then select the appropriate unit on the Ruler Units drop-down menu in the Display section.You can change the Ruler units setting to display Inches, Centimeters, or Millimeters.
The new setting appears within the rulers in Page Layout view.
You can turn off the display of rulers in Page Layout view. Click the Ruler check box to deselect this option in the Show/Hide group on the View tab.