Microsoft Office Tutorials and References
In Depth Information
Defining a Print Area
Scaling Normally, Excel applies no scaling, printing your worksheet at 100 percent
of the sizes specified for fonts, graphic objects, row widths, and column heights. You
can adjust the scaling to force your printout to it on a single page, or to shrink the
printout so that all rows or columns it on the page. These options work best for
printouts that are just a little bit too large. If you scale the size too small, you’ll end
up with an economical printout that can only be read with a magnifying glass.
Defining a Print Area
For worksheets that you update and print out regularly, you can define a print area that
includes just the portions you want to print. You might choose to exclude the assumptions
and data sections of your budget worksheet, for example, and print just the summary
sections for handout at your executive briefings.
Start by selecting the print range. If you select a noncontiguous range, be aware that each
section prints on a separate page. On the Page Layout tab, in the Page Setup group, click
Print Area and then click Set Print Area. Excel creates a named range called Print_Area on
the current worksheet. If that all sounds too complicated, you can accomplish the same
outcome by making a selection, clicking in the Name box, and then typing Print_Area as
the range name. (Don’t forget the underscore.)
Each worksheet gets its own Print_Area range. If you select Print Entire Workbook in the
Print Settings section in Backstage view, you can preview or print the defined print area on
all worksheets in the current workbook.
Search JabSto ::

Custom Search