Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Printing > Page Setup - Margins Tab< Previous | Next > 

 

Step 1 - Margins

 
 

Margins determine the amount of space between your data and the edge of the paper.

 
 

Default margins are: left: 0.75, right 0.75, top: 1 and bottom: 1. All margin measurements are in inches.

 
 

Adjusting the margins can be an effective way to fitting slightly more on a page.

 
   
 

This allows you to determine the amount of space between the edge of the paper and your data.

 
 

The Preview box will give a good indication as to how the page will look when it is printed.

 
 

Top - The distance from the top of the paper to the start of the data.

 
 

Header - The height of the header.

 
 

Left - The distance from the left side of the data to the edge of the paper.

 
 

Right - The distance from the right side of the data to the edge of the paper.

 
 

Footer - The height of the footer.

 
 

Bottom - The distance from the end of the data to the bottom of the paper.

 

 

If you are using the headers and footers then make sure your top and bottom margins are larger than your header and footer margins.

 
 

You can alternatively change the margins by dragging them visually in the Print Preview window.

 
 

You can change the location of your headers and footers by using the "Margins" tab, and adjusting the "From Edge" value.

 

 

Step 2 - Center on page

 
   
 

Horizontal - Centres your data horizontally on the paper.

 
 

Vertical - Centres your data vertically on the paper.

 

 

Step 3 - Things to Remember

 
 
  • All margin measurements entered on this dialog box are in inches.

     

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >