How to Change Margins in Excel (2 Methods)

Understanding Margins in Excel

In Excel, margins refer to the free or empty space around the edges of a sheet or paper. These margins indicate where you can write or place content. Similar to physical paper, Excel worksheets also have margins. Although margins are not usually visible within the worksheet, they become apparent when you preview or print the document.

Default Margins in Excel

Excel comes with three built-in margin settings: Normal, Wide, and Narrow. Depending on your requirements, you can choose any of these margins. Each margin has its own predefined measurement for spacing. You can set default margins from the Page Layout tab.

Adding margins in Excel

We will use the following dataset to demonstrate the methods:

Dateset for how to change margins in Excel

Method 1 – Changing Default Margins

Option 1.1 – Using Print Preview

  • Click on the File tab.
  • Select Print and then choose Normal Margins.

Enter the File tab for changing margins

  • From the list of default margin options, select Narrow.

Changing margins from the File tab

  • Observe the print preview section—the margin will appear narrow.

Showing margins in print preview

Read More: How to Add Margin in Excel

Option 1.2 – Using the Page Layout Tab

  • Go to the Page Layout tab.
  • Click on Margins and choose the Wide option.

Showing options to change margin from page layout

  • Press Ctrl+P to see the print preview—the margin will now be wider.

Change margin to wide

Read More: How to Change Page Margins to Wide in Excel

Method 2 – Customizing Margins

Option 2.1 – Custom Margins via Page Setup

  • Navigate to Page Layout > Margins > Custom Margins.

Changing margins using the custom margin feature

  • The Page Setup window will appear.
  • Go to the Margins tab.
  • Customize the margin parameters shown in the image marked as 2.
  • Click on the Print Preview button to see the updated margins.

Customize the margins

  • Look at the print preview.

Margin customized according to requirements

We can see the margins have been changed based on the inputted customized values.

  • You can also access the Page Setup feature from the Page Layout tab or the File tab.

Enter page setup from page layout

Enter page setup from the file tab

Option 2.2 – Adjusting Margins in Print Preview

  • Open the print preview by going to File > Print > Print Preview.
  • Click on Show Margins in the right-bottom section.

Showing margin in print preview

  • Drag the margin parameters directly in the print preview.

Dragging margin from the print preview

  • Observe how the margins change. This process can also reveal margins in the print area that were previously hidden.

Removing Page Margins

To remove page margins from an Excel worksheet (so they only appear in print preview):

  1. Go to File > Options > Advanced.
  2. Untick the Show page breaks option.
  3. Click OK.

Removing Page Margins in Excel

  • Now, when you view the worksheet, no margins will be visible.

Margin removed from Excel

Adjusting Cell Margins

To shift data leftward or rightward within cells:

  • Select the range B5:B14.
  • Click Increase Indent from the Alignment group.

Changing cell margins

  • Observe how the data in the selected cells shifts to the right.

Cell margin left shifted

How to Set Page Orientation in Excel

In this section, we’ll configure the page orientation in Excel, which will be reflected in the print preview. By default, Excel uses Portrait orientation, but we’ll change it to Landscape.

  1. Go to the Page Layout tab.
  2. Click on Orientation and select Landscape.

Changing page orientation

  • Observe that the worksheet is initially set up in Portrait mode.
  • Look at the dataset—the worksheet is now in landscape mode.

Setting up page orientation

Frequently Asked Questions

1. How to Change Margins for All Sheets in Excel?

    • You can easily change margins for multiple or all sheets in Excel. First, select the desired sheets using Ctrl or Shift, and then follow any of the methods explained in this article.

2. How to Adjust Header and Footer Margins in Excel?

    • Yes, you can adjust header and footer margins in Excel using the custom margin feature.

3. Can I Set Different Margins for Different Parts of a Worksheet in Excel?

    • No, you cannot set different margins for different parts of a worksheet. The margin style or parameter applies to the entire sheet. However, you can change the margin style for different sheets within a workbook.

4. How to Fix Excel Margins That Don’t Fit on a Page?

    • Use the Page Setup feature:
      • Open the Page Setup window (as shown previously).
      • Go to the Page tab.
      • Click on Fit to and insert a desired number.
      • Finally, click OK.

Margins fit to page in Excel

5. How to Fix Disappearing Margins in Excel?

    • If margins have disappeared from the print preview in Excel, you can easily solve this problem. Go to the File tab and select Show Margin.

Download Practice Workbook

You can download the practice workbook from here:

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Mohammad Shah Miran
Mohammad Shah Miran

Mohammad Shah Miran has a professional background spanning over a year at Softeko. Initially starting as an Excel and VBA writer, he authored more than 50 articles for the ExcelDemy project. Currently, Miran is engaged in the LinuxSimply project as a Linux content developer, completed over 40 articles. His analytical approach extends across various domains, including Excel, VBA, Bash scripting, Linux, data analysis, and Python programming. In his leisure time, Miran enjoys watching movies and series or listening... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF