Microsoft Office Tutorials and References
In Depth Information
Title Search
column of a wide, multi-columned worksheet and you need to see those months on every print page,
click anywhere in the month column and it will appear on every sheet. ( Note : This option is only
available via the Page Layout tab Pa g e Se tup Sheet sequence. You can’t access it in the Print
Preview – you’ll find Rows to Repeat on Top grayed out there if you do.) And there’s something else to
keep in mind here, too: by selecting the A1:E100 print range as well as choosi n g r ow 1 to r e pe a t on top,
you might think that row 1 will print twice on the first printed page as a result. But it won’t: Excel is
smart enough to understand what you had in mind, and you’ll see row 1 but once on page one.
The Sheet tab also contains a few other options you may want to know about. The Print section
there lists a quartet of check box items, starting with Gridlines . Checking this will enable you to print
the gridlines that you see traced around every cell (at least by default) on the worksheet. This is an
allor-nothing command, however, meaning that any empty cell you’ve included in a print range will also
sport gridlines in the printout. (As a result, you may want to use one of the Border options in the Font
button group on the Home tab instead, in order to draw lines around only the cells you want.) Black
and White will output your worksheet in those famously binary colors, even if you’re working with a
color printer, the better to save color toner. Draft quality is another economical print option,
instructing your printer to roll out your worksheet at a lower print resolution—assuming your device
is capable of varying its print quality in this way.
Row and column headings is a selection you see utilized now and then, enabling you to actually
print the alphabetical and numeric column and row borders of the worksheet. Avail yourself of this
option and your print will look something like this (Figure 9-22):
Figure 9–22. Print preview, with row and column headings set to print
This option might prove instructive to readers who want to visually line up the data in their cell
addresses.
An d mov i n g down a bi t on the She e t tab y ou’ l l se e Page Order , an option that comes into play for
un usua l l y l on g a n d wi de pr i n touts. If y ou n e e d to pr i n t a l a r g e n umbe r of col umn s a n d r ows y ou ma y
wind up printing pages in both directions—that is, pages that print the rows downward across the
width of the page, but also another set of pages that print the “excess” columns spilling across
horizontally, containing the row data sitting beneath those columns. By default, Excel will print data
Down, then over, meaning that if your print area is say, 20 columns wide by 500 rows high, the printout
will first print “downwards”, until all 500 rows are printed with as many columns as can be
accommodate d on those pag e s, an d then will print the remaining columns streaming across the extra
 
Search JabSto ::




Custom Search