Microsoft Office Tutorials and References
In Depth Information
Printing As You See Fit
because, for example, you may have to print a couple of thousand rows of data—and so we’re not
dealing with the one-versus-two page spillover problem we described earlier in the Fit Sheet on One
Page discussion. Here the issue is one of print width versus print length. We’re prepared to roll out
dozens of pages worth of table rows—but we still want the table fields, or columns , to all a ppe a r on
every page of the printout, and it’s this print objective that Fit All Columns on One Page carries off.
Thus if you have 50 pages worth of table rows streaming down the pages vertically, so be it—but if one
table column also spills over onto a second page horizontally , y ou’ l l wi n d up wi th a 1 0 0- pa g e pr i n tout,
because every row needs to display its data beneath that excess column, too. And that’s downright
gauche—but it doesn’t have to happen, unless you have dozens of table fields to work with, and fitting
them all horizontally on one page crunches the data into text best viewed under an electron
mi cr oscope .
The companion option—Fit all Rows on One Page—resolves the same sort of print issue, but in a
perpendicular direction. If you want to print a table say, three columns wide by 50 rows high, it’s
possi bl e tha t a r ow or two wi l l cr e e p on to a se con d pa g e , de pe n di n g on y our cur r e n t ma r g i n s, r ow
heights, and the like. Use Fit all Rows to reel those truant rows back onto one, all-encompassing page.
But note that the Scaling drop-down menu also sneaks in the Custom Scaling Options… selection,
which when clicked opens the stalwart Page Setup dialog box, treating you to a couple of additional
scaling possibilities (Figure 9-8):
Figure 9–8. Adjusting the print size