How to Deal with Margin Problem While Converting Excel to PDF

Get FREE Advanced Excel Exercises with Solutions!

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.

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 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.

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 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

<< Go Back to Export Excel to PDF | Export Data from Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Aniruddah Alam
Aniruddah Alam

Md. Aniruddah Alam, a graduate of Bangladesh University of Engineering & Technology, Dhaka, holds a BSc.Engg in Naval Architecture & Marine Engineering. Joining Softeko in August 2022 as an Excel and VBA content developer, he has authored 90+ articles, covering fundamental to advanced Excel topics. He actively develops VBA codes for Excel automation and offers solutions in the Exceldemy Forum. Beyond work, he finds leisure in reading books, and taking relaxing walks, showcasing well-rounded blend of professional and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo