In Excel, if you want to print a paper report, you have the option to change the page margins according to your need. By default, the margins that you have are 1.78 cm for the left and right, and 1.91 for the bottom and top.
You can change these margins as per your requirement. In this tutorial, we will look at all the different options and methods that you have in Excel to change the page margins.
Change Page Margin in Excel
- First, go to the Page Layout Tab.
- After that, go to the page setup option group.
- Next, click on the “Page Layout” drop-down.
- In the end, select the page margin setting that you want to use.
There are three major pre-defined settings you can use: Normal (Default), Wide, and Narrow.
Custom Page Margins
You can also use custom page margin values. When you margin drop-down from the page layout, click on the “Custom Margin” option, and open the dialog box. You can also use the keyboard shortcut, Alt ⇢ P ⇢ M ⇢ A.
In the dialog box, you can change the page margin values and set a new one.
You can also change the values for the header and footers and make content at the center vertically and horizontally.
Adjust Margins from Print Preview Window
When you open the print preview, you have the option there also to change the margins. In the settings section, scroll down to the bottom and click on the margin drop-down.
When you click on it, you will have the pre-defined settings, and custom margin option, and you also select the last used setting.
This is the same list of options that you have in the page layout tab on the ribbon.
Show Margins and Change them with Mouse
You can also use the “Show Margin” option in the print preview, to change margins with your mouse cursor. On the bottom right of the print preview window, there’s a tiny button, click it to activate.
The moment you click on it, it gives you a preview of all the margins on the page, and you change it with the mouse cursor.
When you have multiple worksheets in your workbook, and you want to use a custom margin value for the print, well, you need to change it for each sheet.