Microsoft Office Tutorials and References
In Depth Information
You can set the margin setting in two ways. The easiest approach is to pick one
of the presets (Normal, Wide, or Narrow), as shown in Figure 14-37.
Each margin preset
numbers. The Top,
Bottom, Left, and
Right values measure
the amount of space
worksheet content and
the top, bottom, left,
and right edges of the
For more control, you can choose Custom Margins and fill in your own margin
values (Figure 14-38). Logically enough, when you reduce the size of your
margins, you can accommodate more information. However, you can’t completely
eliminate your margins. Most printers require at least a little space (usually no
less than .25 inches) to grip onto the page, and you won’t be able to print on this
part (the very edge of the page). If you try to make the margins too small, Excel
won’t inform you of the problem; instead, it’ll just stick with the smallest margin
your current printer allows.
If you have only a few rows or columns of information, you may want to use
one of the “Center on page” options. Select Horizontally to center your columns
between the left and right margins. Select Vertically to center your data between
the top and bottom of the page.
Tip: A good rule of thumb is to adjust margins symmetrically (printouts tend to look nicest that way).
Thus, if you shrink the left margin to 0.5, make the same change to the right margin. Generally, if you
want to fit more data and you don’t need any header or footer space, then you can safely reduce all your
margins to 0.5. If you really want to cram in the maximum amount of data you can try 0.25, but that’s the
minimum margin that most printers allow.