How to Add Margin in Excel (7 Effective Ways)

Microsoft Excel is a very useful software. We use Excel functions and features for our educational, business, and other daily life purposes. Furthermore, Excel provides some cool features to add margins to our workbooks. This article will show you 7 easy ways to Add Margin in Excel.


Download Practice Workbook

You can download this workbook to practice yourself.


7 Effective Ways to Add Margin in Excel

Using Excel we have created a dataset that represents the yearly sales budget and records of salespersons of a company. Let’s say, we want to print it to make a hard copy. Therefore, we need to add margins to bind the Excel documents. Moreover, adding margins is the best way to make Excel workbooks more professional. In this article, I will show you 7 easy ways to add margin in Excel. For instance, we want to create a margin for the dataset below.

how to add margin in excel


1. Add Custom Margin from Page Layout Tab in Excel

In order to add margins before making a hard copy, we can add a custom margin feature from Page Layout. The custom margin feature provides you the flexibility to add space to your workbooks. We can add or remove margins on the left, right, up, and bottom of the sheets. Follow these easy steps on how to add custom margins in Excel.

Steps:

  • Firstly, go to the Page Layout tab and click the Margins tab within the page setup ribbon.

Add Custom Margin from Page Layout Tab in Excel

  • Later, tap Custom Margins to open up the margin dialogue box.

NOTE: You can also open the Custom Margins by clicking the Page Setup icon. As a result, the Custom Margin menu will pop up automatically.

  • Now, press Margins in the custom menu.
  • Here, you can customize your margins to any format you wish.
  • Also, you can tap Print Preview to see how it will look after printing.
  • Lastly, to save our format, hit OK.

  • As a result, the desired custom margin appears.

Output of Custom Margin


2. Go to Print Option in File Menu to Insert Predefined Margin

As opposed to the previous method, Excel provides some built-in margin options to add margins. They are less time-consuming and easy to access. Let’s see these procedures to add predefined margins.

Steps:

  • In the beginning, go to File and tap Print.
  • Subsequently, you can see the preview on the right and access it.

Go to Print Option in File Menu to Insert Predefined Margin

  • After that, move to Settings options and click Normal Margins.

  • Consecutively, a dropbox will appear with some predefined margin options.
  • Here, select any options you like.
  • To illustrate, we select Wide margin as our dataset is not too large.

  • Finally, a wide margin appears in the preview pane.

Output of Predefined Margin

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


3. Use Wrap Text Feature to Add Margin

The wrap text feature is a built-in feature in Excel. We can use this feature to add margins around the texts. Wrap text automatically adjusts in the cells when we define a format for adding margins. Let’s follow these steps to understand it.

Steps:

  • Firstly, go to the Home tab and click Wrap Text.
  • Then, click File then tap Print.

Use Wrap Text Feature

  • After that, in the settings options, press Page Setup.

  • Eventually, a Page Setup dialogue box will appear.
  • Here, select Margins.
  • Later, move to Center on page and check Horizontally & Vertically.
  • Finally, select Ok.

  • Thereupon, the dataset appears in the center of the margin.

Output of Wrap Text Feature

Read More: How to Apply Margin Setting in Excel (2 Handy Approaches)


4. Add Margin by Changing Page Orientation

If you want to print your dataset perfectly with added margins around your texts, you can change the page orientation of the workbook. Let’s follow these procedures:

Steps:

  • To begin with, go to Page Layout, and tap Orientation.
  • Next, select Landscape.

Add Margin by Changing Page Orientation

  • Finally, the output appears in Landscape.


5. Customize Page Size for Adding Margins in Excel

Similarly to the previous method, we will use the Size tool in the Page Layout tab for adding margin. Follow these procedures:

Steps:

  • First, move to the Page Layout and go to Size.
  • Subsequently, a dialogue box will appear.

Customize Page Size for Adding Margins

  • Now, select any format you like in your dataset.
  • For instance, we take Legal.

  • After that, go to Page Layout and click the Page Setup dropbox.

  • Now, tap Page in the dialogue box.
  • Finally, press OK.

  • Therefore, the result will appear.

Output of Page Size Customization

Read More: [Fixed] Excel Margins Not Printing Correctly (6 Possible Solutions)


6. Apply Excel Page Scaling Feature to Add Margin

Again, like the previous method, we use a scaling tool in the page layout to add margin in Excel. Follow the steps.

Steps:

  • First of all, tap the dropdown icon in the page layout.
  • Later, a dialogue box will appear.

Apply Excel Page Scaling Feature

  • Next, select Page and go to the Scaling box.
  • Here, adjust your dataset margin.
  • Lastly, hit Ok to get the final result.


7. Define Print Area in Excel to add Margin

In this method, we will add the margin in Excel documents using the Print Area in the Page Layout. For this implementation, we follow these steps.

Steps:

  • Select the Print Area in the page layout.
  • Then, tap the Set Print Area.

Define Print Area in Excel

  • Eventually, in the dropbox, tap print active sheets and then print selection.

  • Hence, the desired result will pop up.

Output of Defined Print Area

Read More: How to Remove Print Margins in Excel (3 Quick Tricks)


Conclusion

In conclusion, we have discussed here some easy ways to add margin in Excel. Not to mention, our ExcelDemy website shows various simple problem-solving methods like this. Please leave any further queries or recommendations in the comment box below.


Related Articles

Yousuf Khan

Yousuf Khan

Hello! This is MD Yousuf Khan. I am a graduate & post-graduate in Information Technology from Jahangirnagar University, Bangladesh. Currently, I am working as a web content developer at SOFTEKO. I write articles in Microsoft Excel. I am an independent, self-motivated person with enthusiasm to learn new things, and always try to do my best in any work assigned to me.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo