Microsoft Office Tutorials and References
In Depth Information
The Print Area Option
Note the page count at the bottom of the page: 14. That means if we launched a printout right now
Exce l woul d pr i n t the entire table, because we’ve temporarily overridden the A1:E50 print range and
returned to the Print Active Sheets default, as it’s shown in the Backstage. Then by clicking Ignore
Print Area off , we’ll return to the A1:E50 selection. And you can turn your Print Area off permanently by
cl i ck i n g Pa g e La y out Print Area Clear Print Area .
The Pages option enables you to indicate which pages you want printed, in the
event your selected print range—or the entire active sheet - spans more than
one page. Note by default the page number fields are blank. By clicking the
horizontal arrows at the bottom of the page you can view how your data appear
before selecting your pages. What this means is that if you select some, but not
all, of the pages to print you’re really carrying out a kind of alternative Print
Selection command. Note as well that, unlike Word, you can’t print
nonconsecutive pages in Excel.
The Collated opti on s r e a l l y on l y a ppl y to mul ti - pa g e , mul ti - copy pr i n touts a n d
work very similarly to the way in which they work in Word. By default, Excel
collates by printing copies separately in their page sequence. Thus if we were to
print three copies of the entire Source Data sheet in the SampleSalesPerson
workbook, we’d roll out all 14 pages, 1-14, three times. The Uncollated (another
Un word—even Word redlines it) option, however, prints all the page ones, twos,
threes, etc. together in that sequence. Printing the Source Data sheet in
Uncollated fashion would yield three page ones, three page twos, etc. And why
would one want to print this way? Perhaps because a lecturer who needed to
enter some handwritten corrections on all the page ones, for example, could
mor e e a si l y g r a b e v e r y copy of tha t pa r ti cul a r pa g e v i a a n Un col l a te d pr i n tout.
Portrait Orientation is Excel’s default print orientation. That is, leave this option
as is and your printout will appear in a vertical, upright position. Your print
needs may often require a landscape, or sideways orientation, though, and if
that’s the case simply click the Landscape orientation. Either way, the Print
Preview will display the pages in the selected orientation. (Note: You can also
access the Orientation option by clicking the Printer Properties link beneath the
Printer drop-down menu, as well as by clicking the Page Layout tab Pa g e Se tup
Orientation.)
The Letter dr op- down me n u pr ov i de s a se r i e s of pa pe r si ze s y ou ca n se l e ct for
y our pr i n t. Natur al l y , the stan dar d 8½ x 11 si ze appe ar s by de faul t (or A4 i f
you’re on the other side of the pond), but the associated drop-down menu stocks a
long list of additional options. And if those aren’t enough, clicking the More
Paper Sizes… selection calls up the ageless Page Setup di al og box (Fi g ur e 9- 4):
 
Search JabSto ::




Custom Search