Microsoft Office Tutorials and References
In Depth Information
Excel allocates space at the top and bottom of your
printout for a header or footer (page 407). In this
example, the header margin is set to 0.5, which
means that any header information will appear
half an inch below the top of the page. The top
margin is set to 1, meaning the worksheet data
will appear one inch below the top of the page.
When adjusting either of these settings, be careful
to make sure the top margin is always larger than
the header margin; otherwise, your worksheet’s
data will print on top of your header. The same
holds true with footers when changing the bottom
margin. (But if you aren’t using headers or footers,
their margin settings don’t matter.)
8. If you need to shrink your printout and crammore information into each
No matter how drastically you reduce your margins, you’ll only be able to fit
a few extra rows and columns in a page. A more powerful approach for fitting
mass amounts of data into a smaller number of pages is to use scaling . Page 410
gives more detail, but for now, you can try one of the handy scaling presets:
— Fit All Columns on One Page squashes your page width-wise, making it
narrower. This way, the columns won’t leak off the edge into a separate page.
— Fit All Rows on One Page squashes your page height-wise, making it
shorter. This way, all your rows will appear on the same page.
— Fit Sheet on One Page squashes your page both ways, making sure all your
data fits on a single sheet.
Note: Excel performs scaling by reducing the font size in the printout. If you try to cram too much data
into too small a space, your text might shrink into near-oblivion. It can be hard to judge just how small
your text is from the print preview, so you might need to print your worksheet to see how much scaling is