Microsoft Office Tutorials and References
In Depth Information
There’s More Than One Way to View A Worksheet
can work as usual in any cell on the worksheet here, including those cells that already contain data.
Just remember that by entering information in the Click to Add Data area you’re including those data
in your default print range. Note as well that if you guide your mouse into the narrow gray corridor
between pages in the Page Layout view, you’ll encounter a Hide White Space ca pti on (Fi g ur e 9- 2 4 ):
Figure 9–24. White out: Hiding White Space in Page Layout view
Click there and the header/footer areas on the worksheet—that extensive white space—will be
banished from the screen, leaving you with more of the worksheet proper on which to work. Slide back
into that sliver again between the pages and you’ll see a Show White Space prompt; click there to
expose the header/footer areas.
Any print range you’ve set will continue to be bordered by a dotted line in the Page Layout view.
Recall that we’ve established A1:E100 as that range, an area of cells that should yield a two-page print.
But—and this is easy to miss—check out the left edge of the status bar in our screen shot (Figure 9-25):
Figure 9–25. Print page count in the Page Layout view.
This looks like the sort of message you’d see in Word, but in any case it raises a question: Why 14
pages? It’s because Page Layout tallies the number of pages you’d get were you to print all the data in
the worksheet—even though we want to print just 100 rows. And along these lines, note that Page
Layout continues to display the filter buttons on the table’s header row—but these won’t pr i n t.
You’ve also probably caught the Click to add header area (of course there’s a parallel Click to add
footer section here, too); but before you actually click, roll your mouse over there and note that the header
area turns blue over whichever of the three header sections you’re rolling—that is, the left, center, and