How to Adjust the Margin in Excel (Default/Custom Margins)

Using the Page Layout Tab

STEPS:

• Select the worksheet you want to print.
• Go to the Page Layout tab, and from Page Layout, select Margins.
• From the margin options, choose any predefined margin, such as Normal, Wide, or Narrow.

Click the image for a detailed view

• We chose Normal. To see the applied margin, go to File >> Print.

You can click the image for a detailed view

Using Print Preview Window

• Go to the file tab.

You can click the image for a detailed view.

• Click the Print option from the left-side pane. From there, click the margin options dropdown and choose any predefined margins.

Click the image for a detailed view

How to Set Custom Margins in Excel

• Go to Page Layout >> Margins>> Custom Margins.

Click the image for a detailed view

• You will get the Page Setup dialog box, where you can adjust the Top, Bottom, Left, and Right heights and widths according to your preference. Clicking on the Print Preview button will preview the margin.

You can click the image for a detailed view.

• After clicking the Print Preview button, you will see the view of the custom margin.

Click the image for a detailed view

Read More: How to Add Margin in Excel

How to Change/Adjust Margin with Mouse in Excel

• Go to the Print Preview like the previous method. Then click on the Show Margins button at the bottom right of the window.

• After clicking the Show Margins button, we can see the margins in the preview.

• Drag these margins with your mouse to adjust them.

Click the GIF for a detailed view

Read More: How to Change Margins in Excel

Download the Practice Workbook

How to Adjust Margin in Excel: Knowledge Hub

<< Go Back to Page Setup | Print in Excel | Learn Excel