Microsoft Office Tutorials and References
In Depth Information
Page Layout View: A Better Print Preview
Figure 14-40:
The Page Layout view
shows the first (and
part of the second)
page of this
worksheet’s 64 printed
pages. This worksheet
has 19 columns, but
since they’re wider
than the width of a
single printed page,
the first page includes
only the leftmost
seven columns, as
shown here. You can
scroll to the right to
see the additional
columns that’ll turn
up on other pages,
or scroll down to see
more rows.
Note: Don’t confuse Page Layout view with an ordinary print preview (like the one you see when you
choose File➝Print). A print preview provides a fixed “snapshot” of your printout. You can look, but you
can’t touch. Page Layout view is vastly better because it shows what your printout will look like and it lets
you edit data, change margins, set headers and footers, create charts, draw pictures—you get the idea. In
fact, you can do everything you do in Normal view mode in Page Layout view. The only difference is you
can’t squeeze quite as much data into the view at once.
If you aren’t particularly concerned with your margin settings, you can hide your
margins in Page Layout view so you can fit more information into the Excel window.
Figure 14-41 shows you how.
Here are some of the tasks you may want to perform in Page Layout view:
To tweak print settings and see the effect, choose the Page Layout tab in the
ribbon. The most important print-related sections are Page Setup (which lets
you change orientation and margin settings), Scale to Fit (which lets you cram
more information into your printed pages), and Sheet Options (which lets you
control whether gridlines and column headers appear on the printout).
To move from page to page, you can use the scroll bar at the side of the
window, or you can use the keyboard (like Page Up, Page Down, and the arrow
keys). When you reach the edge of your data, you see shaded pages with the text
“Click to add data” superimposed. If you want to add information further down
the worksheet, just click one of these pages, and then start typing.
Search JabSto ::

Custom Search