How to Deal with Margin Problem While Converting Excel to PDF

Microsoft Excel offers a native option to export an Excel file to PDF. Furthermore, it also provides Microsoft Print to PDF option. However, while exporting excel data to a pdf file, we may find some issues with the margin of the PDF file. In this article, I will discuss some solutions related to Excel to PDF margin problem.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Why Does PDF Margin Problem Occur?

PDF margin problems may occur due to various reasons. The main common reason is due to not configuring the parameters of the margin properly. Another reason could be improper page size. If the size of the paper is changed, the margin may be displayed differently in PDF.


2 Useful Methods to Solve the Problems While Exporting Excel to PDF

In this section, we will demonstrate 2 effective methods to solve Excel to PDF Margin Problem.  As PDF can be exported mainly in two ways, we have explained the solution for each approach. Let’s begin with the 1st solution.


1. Customization of Margin in Microsoft Print to PDF Option

Sometimes, we may find the margin of the exported pdf file is not as we expect while printing through Microsoft Print to PDF option. To customize the margin of the exported pdf file, follow the steps below.

Steps:

  • Go to File > Print.

  • Then, from the Printer Option in the pop-up window, select the Microsoft Print to PDF

  • Before going to customize the margin, first you have to check the Page Size, Orientation, and Scaling.

  • After ensuring that all those parameters are in your desired conditions, you can go for the Margin
  • Now, by clicking on the Margin Option, you will see many 3 predefined margin options(Normal, Wide & Narrow). If your needs are satisfied with those 3 predefined, you don’t need to go for the customization. Otherwise, select Custom Margin.

Customization of Margin in Microsoft Print to PDF Option

  • Consequently, the page setup window will pop up. Here, you will see many options to customize your page margin. For example, you can vertically or horizontally center the page. Or you can set the margin for each side( Top, Bottom, Left, Right, even Header and Footer).

Customization of Margin in Microsoft Print to PDF Option

  • After doing all those customizations of the margin, you can click OK to save the changes.
  • Finally, you can save the file in PDF type by clicking on Print.

Customization of Margin in Microsoft Print to PDF Option

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


2. Utilizing Save as PDF Option

Besides the Print to PDF option, we can save an Excel file as a PDF after setting the required parameters of Page margins in Excel. To do that, follow the steps below.

Steps:

  • First, we will set the mage margin according to our needs. For that, go to Page layout > Margin > Custom Margins.

Utilizing Save As PDF Option to Solve Excel to PDF Margin Problem

  • Now, set your customized margin and click

Utilizing Save As PDF Option to Solve Excel to PDF Margin Problem

  • Now, to export the Excel file into Pdf, go to File > Save As. On the file format option, choose PDF and then click SAVE. As a result, your file will be saved as a PDF and it will have the margin that you have configured.

Utilizing Save As PDF Option to Solve Excel to PDF Margin Problem

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


Things to Remember

  • Instead of Save As PDF, you can also use the Export as PDF option from the File

Conclusion

That is the end of this article. If you find this article helpful in solving your problem related to Excel to PDF margin, please share this with your friends. Moreover, do let us know if you have any further queries. Finally, please visit Exeldemy for more exciting articles on Excel.


Related Articles

Aniruddah Alam

Aniruddah Alam

Hi, I am Md. Aniruddah Alam from Dhaka, Bangladesh. I have my Bachelor's degree in Naval Architecture from BUET. I love to read books, listen to podcasts, explore new things, walking randomly in unknown places. Currently, I am working as an Excel and VBA Content Developer. I try to present solutions of problems that are faced in excel in an easy and straightforward manner.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo