Microsoft Office Tutorials and References
In Depth Information
Figure 14-36:
When it comes to
printing, Excel’s
Backstage view is
a small miracle of
efficiency. Not only
does it let you tweak
the most common
print settings, but it
also shows you the
effect in an instantly
updated preview.
If this no-fuss printing approach doesn’t give you the results you want, you need to
take a closer look at the print settings you can tweak. Here’s a walkthrough that takes
you through all your options:
1. ChooseFile Print(orpressCtrl+P).
Excel switches into Backstage view, and shows a two-part display that puts
printing options on the left and a print preview on the right (Figure 14-36).
2. Ifyouwanttoprintmultiplecopiesofyourdata,usetheCopiesbox.
If you want to print more than one identical copy of your data, change the
Copies box accordingly. (This is automatically set at 1 to print a single copy of your
If you’re printing more than one copy and your worksheet has multiple pages,
you should also review the collating setting, which appears further down. This
setting determines whether Excel duplicates each page separately. For example,
if you print 10 pages and your printout is set to Uncollated, Excel prints 10
copies of page 1, 10 copies of page 2, and so on. If your printout it set to Collated,
Excel prints the entire 10-page document, then prints out another copy, and
so on. You’ll still end up with 10 copies of each page, but they’ll be grouped
together for added convenience.
Search JabSto ::

Custom Search