How to Create a New Custom Dictionary in Excel 2007
How to Use Excel 2007’s Research Task Pane
Translating Text in Excel 2007

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.

Viewing a worksheet in Page Layout view.
Viewing a worksheet in Page Layout view.

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:

  1. Click the Office button and then click the Excel Options button.

    The Excel Options dialog box appears.

  2. 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.
    You can change the Ruler units setting to display Inches, Centimeters, or Millimeters.
  3. Click OK.

    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.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
How to Use the Thesaurus in Excel 2007
Scrolling through an Excel 2007 Worksheet
Working with the Excel 2007 Mini Toolbar
Exploring the Excel 2007 Program Window
Examining the Excel 2007 Status Bar
Advertisement

Inside Dummies.com