Microsoft Office Tutorials and References
In Depth Information
Printing As You See Fit
(Note : T he Pa g e Se tup di a l og ca n a l so be a cce sse d by cl i ck i n g the Page Setup link at the bottom of
the Pr i n t di al og box, as we l l as by cl i cki n g the di al og box l aun che r i n the Pag e Se tup button g r oup on
the Page Layout tab.)
Printing As You See Fit
The final option in the Settings group in the Print menu controls Scaling (sounds like a hair shampoo).
By default, Excel prints sheets “at their actual size,” a rather ambiguous instruction that means that the
printout will emerge as it initially looks in the Print Preview. But you can modify that hard copy
outcome, and there may be good reasons to want to do so. Note these drop-down scaling options
(Figure 9-7):
Figure 9–7. Print scaling options
Moving past the No Scaling default we’re brought to the Fit Sheet on One Page option, an
important one that addresses a classic spreadsheet print challenge: how to deal with a worksheet
whose contents when printed will spill onto a second page—barely, by just a few rows or so. Printing
here with No Scaling will yield an unsightly Page Two, consisting of but that smattering of data. Click
Fit Sheet on One Page however, and all the worksheet data will be ever-so-slightly-downsized, all
amicably sharing one, smartly presented page.
Of course, Fit Sheet on One Page needs to be used with care. I once accidently printed a lengthy
wor ksheet under that option, and the one-page result looked like raw seismographic data, or
someone’ s EKG readout. Ah, well…we lear n fr om our mistakes.
The other two drop-down options— Fit All Columns on One Page and Fit All Rows on One Page
address related print issues. If your printout as engineered by the No Scaling mode results in one
lonely column being elbowed onto a second page, that’s not going to look very nice—but we need to
figure out what’s really going on here. The printout in question could in fact be dozens of pages long—
Search JabSto ::

Custom Search