Setting Margins

Contact Us or call 1-877-932-8228
Setting Margins

Setting Margins

You can increase and decrease margins in Microsoft Excel worksheets to change the amount of white space that shows up between your data and the edge of the page when you print. By default, top and bottom margins are .75 inches, side margins are .7 inches, and header and footer margins are .3 inches.

To set the margins in a worksheet:

  1. On the PAGE LAYOUT tab, in the Page Setup group, click the Margins command:Margins in Page Setup Group of Page Layout Tab
  2. Select from the options available (Last Custom Setting, Normal, Wide, or Narrow) or select Custom Margins to set your own margins:Margin Options
  3. If you select Custom Margins, you will be presented with the Page Setup dialog box, where you can set all margins. Note that on the Margins tab of the Page Setup dialog box, you also have the option to center your data horizontally or vertically on the page. After setting your margins, click OK:Page Setup Dialog Box
Next