Why does printing from Excel to pdf not maintain the size/border of the original Excel doc?

I'm trying to print from Excel to pdf - I've followed advice I've seen online and the print preview looks fine. The printed pdf on the other hand looks totally different, with a large white border. Pictures below.

I've also tried using VBA, as follows:

ActiveSheet.ExportAsFixedFormat Type:=x1TypePDF, OpenAfterPublish:=True

Would appreciate any advice at all here. Thanks

1 Answer

Microsoft Print to PDF has a number of settings in the print dialog, such as paper size (e.g., 8.5x11 inch, A3 or A4), number of sheets per page (e.g., one can print 1, 2 or even 6 spreadsheets on on piece of paper), whether to scale to page, or not, etc. Your default settings likely are not correct for the paper you use.

To set the default printer setup,

• Open the Devices and Printers dialog.
• Select Microsoft Print to PDF.
• Right-click, and set Printing preferences, including Advanced, appropriately.
• Right-click and set Printing properties appropriately.

Next time you use PDF printing, the new defaults should work.