How to Deal with Margin Problems While Converting Excel to PDF – 2 Solutions

Solution 1 – Customizing the Margins in the Microsoft Print to PDF Option

To customize the margins:

Steps:

  • Go to File > Print.

  • In Printer Option, select the Microsoft Print to PDF.

  • Check Page Size, Orientation, and Scaling.

  • Click Margin.
  • Select Custom Margin.

Customization of Margin in Microsoft Print to PDF Option

  • Customize your page margins: center the page vertically or horizontally, set the margins for Top, Bottom, Left, Right, Header and Footer.

Customization of Margin in Microsoft Print to PDF Option

  • Click OK.
  • Save the file as a PDF by clicking Print.

Customization of Margin in Microsoft Print to PDF Option

Read More: How to Convert Excel to PDF without Converter


Solution 2 – Utilizing the Save as PDF Option

Steps:

  • Go to Page layout > Margins > Custom Margins.

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

  • Set your customized margins and click OK.

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

  • Go to File > Save As.
  • Choose PDF and click SAVE.

Your file will be saved as a PDF.

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 in the File Options.

Download Practice Workbook

Download this practice workbook to exercise.


 

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
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