Defining Page Setup Options

In Excel XP page setup options can help you make your worksheet look more professional. Learn all about using the page setup feature in Excel XP here.

Setting page margins

The page margins define where on the page Excel will print the worksheet. By default, the top and bottom margins are set at 1 inch in Excel XP, while the left and right margins are set at 0.75 inch. Margin settings can be changed to whatever you want. Different margins can be defined for each worksheet in the workbook.

To change the margins in the Page Setup dialog box:

  • Select the correct worksheet.
  • Choose FilePage Setup from the menu bar.

    File and Page Setup Menu Selections
  • Select the Margins tab.

    Margins Tab on the Page Setup Dialog Box
  • Use the spin box controls to define the settings for each page margin—top, bottom, left, right, header, and footer.
  • Click OK to change the margin settings.