Microsoft Office Tutorials and References
In Depth Information
Previewing Pages in Page Layout View
When breaking a worksheet into pages, Excel first pages the document
vertically down the rows in the first columns of the print area (just like a word
processor). After paging the first columns, the program pages down the rows
of the second set of columns in the print area. Excel pages down and then
over until the entire document included in the current print area (which can
include the entire worksheet or just sections) is paged.
When paging the worksheet, Excel doesn’t break up the information within
a row or column. If not all the information in a row will fit at the bottom of
the page, the program moves the entire row to the following page. If not all
the information in a column will fit at the right edge of the page, the program
moves the entire column to a new page. (Because Excel pages down and then
over, the column may not appear on the next page of the report.)
You can deal with such paging problems in several ways, and in this chapter,
you see all of them! After you have these page problems under control,
printing is a proverbial piece of cake.
Previewing Pages in Page Layout View
Excel 2013’s 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 by clicking the Page Layout View command button on the Ribbon’s
View tab (Alt+WP). As you can see in Figure 5-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, any headers and footers defined for the report,
and the breaks between each page. (Often, you have to use the Zoom slider
to reduce the screen magnification to display the page breaks onscreen.)
To see all the pages in 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 units, open
the Advanced tab of the Excel Options dialog box (File Options Advanced
or Alt+FTA) and then select the appropriate unit (Inches, Centimeters, or
Millimeters) on the Ruler Units drop-down menu in the Display section.
The Ruler check box on the View tab acts as a toggle switch so that the first
time you click this button, Excel removes the rulers from the Page Layout
view, and the second time you click this button, the program adds them
again.
Search JabSto ::




Custom Search