Microsoft Office Tutorials and References
In Depth Information
Adjusting Page Layout
Excel provides several ways to view your
data. Most of the time when you work in Excel
you will be working in the Normal view, but your
data is fully editable in any of these views.
To switch to another view, choose View >
Workbook Views from the Excel Ribbon.
Alternatively, you could use the View icons
in the status bar (see Figure 9-10).
Normal view: The default view you see
when you open Excel. Page breaks are
indicated with dotted lines.
Page Layout view: This view is a more
powerful version of the Print Preview
Excel’s status bar contains the
View icons and Zoom slider.
Page Break preview: This view condenses
the print area of the worksheet and
enables you to manually adjust page
Use the Zoom slider to change the
magnification level within each view.
Figure 9-11 demonstrates that unlike
the Normal view, the Page Layout view displays
portions of the worksheet that are usually hidden
until you view them on the Print Preview window.
Instead of using dotted lines to indicate a page
break, the Page Layout view shows an actual break
in the worksheet as if you were looking at a
piece of paper. Using this view allows you to
make changes to elements of your document
that are not normally visible, such as margins,
titles, and headers and footers.