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!
You should read it
- Guidance on how to align Excel correctly
- Instructions for alignment in Excel - Adjust the margins for Excel before printing
- How to Set Margins in Microsoft Publisher
- Align text correctly in Excel
- How to align correctly in Word
- Page numbering method of type 1/2 in Excel
- How to delete white pages in Excel
- How to align in Word extremely accurately
- Page numbering in Excel does not start with number 1
- How to remove words Page in Excel, delete sinking text Page 1, Page 2 in Excel
- How to align an Excel page so that when it fits on A4 page
- How to repeat titles in Excel 2007, 2010 and 2013 when printing