Set page margins

To better align a Microsoft Excel worksheet on a printed page, you can change margins, specify custom margins, or center the worksheet horizontally or vertically on the page. Page margins are the blank spaces between the worksheet data and the edges of the printed page. Top and bottom page margins can be used for some items, such as headers, footers, and page numbers.

  1. Click the sheet

  2. Click Page Layout > Margins > Custom Margins.

    Custom Margins
  3. In the Page Setup dialog box, under Center on page, select Horizontally and Vertically. This will center the sheet on the page when you print.

  1. Click the sheet.

  2. On the Layout tab, under Page Setup, click Margins.

    Layout tab, Page Setup group .

  3. Click Custom Margins, and then adjust the margins as you want them to appear.

    To center the sheet on the page when you print, under Center on page, select Horizontally and Vertically.

    Tip: To hide the page break lines, on the Layout tab, in the View group, clear the Breaks check box.

See Also

Print cell gridlines

Print part of a sheet

Scale the sheet size for printing

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×