Microsoft Office Tutorials and References
In Depth Information
Printing a Worksheet
INSIDE OUT Make a printout it in a specific number of pages
If you want your printed worksheet to it in a specific number of pages, Excel can
calculate the scaling percentage for you. From the Print tab in Backstage view, click the
current scaling option and then click Custom Scaling Options. On the Page tab of the Page
Setup dialog box, click Fit To. Pick two numbers if you know exactly how many pages
you want to use. (Leave one number blank if you don’t want Excel to automatically
scale in that dimension.) Click OK to save your settings, check the preview to verify that
your worksheet’s print settings are correct, and then click Print.
The controls under the Print and Printer headings are pretty self-explanatory. Be sure the
right printer is selected, adjust the number of copies to print if you need more than one,
and then click the big Print button. The choices under the Settings heading deserve a little
● What to print The preset options allow you to print the current selection, print the
active sheets (select multiple tabs if you want to print more than one), or print the
Collated? The default option prints multiple copies in complete sets, one after the
other. Choose Uncollated if you want to print all copies of page 1, then all copies of
page 2, and so on.
● Orientation Portrait Orientation is the best choice for lists and summary pages
that are formatted like a Word document. Annual budgets and other financial reports
that tend to be wide, with long row labels and grand total columns or notes, are
typically more readable when you switch to Landscape Orientation.
● Paper size The default size is dictated by your country setting; in the U.S., that’s
Letter (8.5”x11”). You can choose from a fairly long list of preset sizes, including the
European A4 standard, or click More Paper Sizes to choose from a potentially longer
● Margins The default Normal setting adds 0.75” at the top and bottom and 0.7” on
either side, with an extra 0.3 inch for a page footer and header. You can choose from
Wide and Narrow options to add or tighten white space around the printed
content on the page. If none of those settings are exactly right, click Custom Margins to
tweak all four sides, adjust the depth of the Header and Footer areas, and center the
content on the page, as shown next.