Microsoft Excel offers a native option to export an Excel file to PDF. Furthermore, it also provides a 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.
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.
How to Solve the Problems While Exporting Excel to PDF: 2 Creative Ways
In this section, we will demonstrate 2 effective methods to solve Excel to PDF Margin Problems. 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 and 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 Convert Excel to PDF without Converter
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 Convert Excel to PDF without Losing Formatting
Things to Remember
- Instead of Save As PDF, you can also use the Export as PDF option from the File Options.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
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.
Related Articles
- How to Convert Excel to PDF with All Columns
- How to Save Excel as PDF on One Page
- How to Save Multiple Excel Sheets as One PDF
- How to Create a Fillable PDF from Excel
- [Fixed!] Excel to PDF Size Problem While Printing
- [Fixed!] Excel to PDF Hyperlinks Not Working
- How to Save Excel as PDF without Cutting Off
- Export Excel to PDF with Hyperlinks
<< Go Back to Export Excel to PDF | Export Data from Excel | Learn Excel