Excel 2010’s Page Layout view gives you an instant view of how printed Excel pages will look. You activate this view by clicking either 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.
Windows keyboard layout and Mac keyboard layout do not match. In order to resolve this issue, you need to install Parallels Tools from Virtual Machine > Install Parallels Tools menu item and do the following: Go to Start > Control Panel -> Regional and Language options and find the following keyboard input languages available for.
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 worksheet, 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 computer). To change the ruler units, follow these steps:
- Click the File tab and then click Options.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.
- Click OK.The new setting displays 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 group on the View tab.