Microsoft Office Tutorials and References
In Depth Information
There’s More Than One Way to View A Worksheet
pages—those columns and row data that couldn’t fit on the first set of pages. Select Over, then down ,
and the printout will print everything “across”—that is, all 20 columns across the first two pages, with
as many rows beneath them as can be fit, and then another 20 columns across, with the next batch of
rows, etc.
There’s More Than One Way to View A Worksheet
Open a worksheet and by default its contents flash onscreen in what’s called the Normal view. But
Excel makes alternative views of the worksheet available, too, and there are reasons for wanting to
switch to them, at least on occasion. In fact, we’ve already worked with one such alternative—the Print
Preview—throughout this chapter. But other viewing options are out there, too, among these the Page
Layout view, available in a button bearing that name in the View Tab Workbook Views button group.
T he tool ti p ca pti on a ccompan y i n g the Page Layout button states that clicking the button allows you to
“View the document as it appears on the printed page,” and it goes on to recommend that you should
click here “…to see where pages begin and end, and to see any headers and footers on the page.” All
this sounds good, but that summary could apply just as accurately to the Print Preview, too. There must
be something different about Page Layout, then, and there is. Click it on our Salesperson report print
area and you’ll see (Figure 9-23):
Figure 9–23. The Page Layout view
This view really is different in some important ways. The worksheet column and row headings
remain visible in this view, but they’re separated from the page, to indicate that they won’t be printing
by de fa ul t (but i f y ou do elect to print the row and column headings, they’ll appear twice in this view—
on the margins, as you see in our screen shot, but also on the worksheet proper). Note in addition the
ruler, which allows you to determine how much space on the printed sheet each row and column will
occupy . Mor e ov e r , y ou ca n see tha t Pa g e La y out de l i n e a te s the con tour s of the pa pe r pa g e , showi n g
where the edge of a sheet gives way to the next sheet.
It’s also important to understand that the Page Layout view is live—that is, you can actually enter
data while working in it. You’ll note the Click to Add Data prompt on the far right of the screen shot
above, a slightly misleading instruction because it implies you can only enter data there. Not true; you
 
Search JabSto ::




Custom Search