Aniruddah Alam
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.
- 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).
- 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.
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.
- Now, set your customized margin and click
- 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.
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.
