Microsoft Office Tutorials and References
In Depth Information
Setting the Print Area
The scaling options (see Figure 10–18) allow you to modify the size of
the data to be printed—not by directly changing the font, but rather by
refitting the data on the page so as to tidy the results.
Figure 10–18. Economy of scale: The print scaling options
Here’s a classic example: you need to print data consisting of many
columns, and the print preview reveals that the last column is going to
have to be shunted to a second page, because the first page has
simply run out of room. And that’s messy. By selecting Fit All Columns on
One Page, Excel will slightly downsize all the data on the printout so that
the renegade column will be able to join the other columns on the
first—and what is now the only—page.
Setting the Print Area
In addition to the printing capabilities you’ll find in the Backstage, there are some
additional and important options stored in other areas of the worksheet. You’ve already
seen that by selecting a specific range to print, you can avoid the problem of
overprinting (i.e., printing blank areas of the worksheet that you don’t need to see in your
printed results). But selecting a print range may cause a problem or two on its own,
because once you select that range you need to print it right away. If you decide you
want to work elsewhere in the sheet before printing, you’ll have to click elsewhere to
begin your work, which will deselect the range you want to print.
Search JabSto ::

Custom Search