Margin Management

Need a little more text room on your page?  Want more white space?  Either way, you may need to play with your print margins.  Of course, you could change them in the Page Setup screen on the Margins tab, but this requires estimating the margin sizes you want.  (Access this via File / Page Setup in Excel 2003 or via Page Layout / Print Titles in Excel 2007.)

Alternatively, if you’d rather ‘eyeball’ the margin sizes, you can go into the Print Preview screen and select “Show Margins.”  This causes fine lines to appear around the preview page, which you can left-click and drag to make the margin larger or smaller as required.   

The second line at the top and bottom designates how much space will be left for the header and footer.  If you don’t have headers or footers, then you could drag the 2 lines to exactly the same spot and it won’t matter.  If you only see one line at the top or bottom, someone has already put the 2 lines in exactly the same spot…just click and drag, and one of the lines will move.  If your text doesn’t move up or down after this as expected, then you likely grabbed the header or footer margin first.  Drag the other line instead and your margins should adjust as required.