Set page margins in Excel

The following article details you how to set print margins in Excel.

Set page margins in Excel Picture 1

Setting margins for pages in Excel is an indispensable operation for print jobs after calculations. To set the margins for the printed page, follow these steps:

Step 1: Go to Home tab -> PageLayout -> click on the arrow below:

Set page margins in Excel Picture 2

Step 2: The Page SetUp dialog box appears with the following options:

- Top: distance of upper margin to printed paper.

- Bottom: the distance of the bottom margin compared to the printed paper.

- Left: the distance of the left margin compared to the printed paper.

- Right: the distance of the right margin compared to the printed paper.

- In the Center on page:

+ If checked, Horizontally: Align all the tables with the paper compared to the paper printed horizontally.

+ If the Hori check box is selected : Align the table evenly compared to the paper printed horizontally.

- Options:

+ Print: Print the spreadsheet.

+ printPreview: Print preview .

+ Options : Other options.

Set page margins in Excel Picture 3

- Depending on the size of the spreadsheet you set the print margins accordingly.

- For example, when selecting print preview mode, PrintPreview spreadsheet is displayed:

Set page margins in Excel Picture 4

- In addition, you can set the type of paper to print vertical or horizontal or paper size by switching to the Page tab :

+ Orientation: Select paper orientation: Portrait - portrait , Landscape - horizontal,  choose paper size in Page size:

Set page margins in Excel Picture 5

Above is a detailed guide on how to set print margins in Excel.

Good luck!