|
Excel 2007's new Page Layout View helps you to visualize the paging of printed reports. When you display this view by clicking the Page Layout View button on the Status bar, Excel doesn't just show the page breaks as measly dotted lines (as in earlier versions), but as actual separations. In addition, the program shows the margins for each page including headers and footers defined for the report (which you can both define and edit directly in the margin areas while the program is in this view).
Couple this great feature with the new Zoom slider in the Status bar and you're going to actually enjoy getting your spreadsheets ready to print!
Displaying Page Layout view
The Page Layout view gives you instant access to the paging of the current worksheet. Activate this feature 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 Ribbon's View tab (Alt+WP).
As you can see in Figure 1, 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 (often you have to use the Zoom slider to reduce the screen magnification to display the page breaks on the screen).
Figure 1: Viewing a spreadsheet in Page Layout view.
 | Select the Ruler check box on the View tab to display the rulers in Page Layout view. Excel displays rulers using the default units for computer (inches on a U.S. computer and centimeters on a European machine). To change the units, open the Advanced tab of the Excel Options dialog box (Office Button --> Excel Options --> Advanced or Alt+FIA) and then select the appropriate unit on the Ruler Units drop-down menu in the Display section (Inches, Centimeters, or Millimeters). |
Using the Zoom Slider
The new Zoom slider appears at the far right side of the Excel 2007 Status bar. Instead of having to select a new magnification percentage for the worksheet from a drop-down menu on some obscure Zoom tool (something you can still do with the Zoom button on the View tab, if you really want to), you can zoom in and out on the spreadsheet in the blink of an eye (actually faster) simply by dragging the Zoom slider right or left.
 | 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. |
| 
