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:
- On the PAGE LAYOUT tab, in the Page Setup group, click the Margins command:
- Select from the options available (Last Custom Setting, Normal, Wide, or Narrow) or select Custom Margins to set your own margins:
- 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: