Skip to main content
dcurtis333
Participant
Aug 21, 2017 7:03 PM UTC
Answered

pdf margin different than printer margin

Why is my bottom margins different when printing an excel document to pdf

This topic is closed to new replies. Start a new post to keep the conversation going.
Dov Isaacs
Dov IsaacsCorrect answer
Legend
Aug 21, 2017 7:28 PM UTC

The margins and a number of other issues associated with layout (including line breaks) are controlled strictly by Excel in conjunction with the print driver. By the time the conversion of PostScript to PDF occurs (when you print to Adobe PDF, Excel creates GDI which is passed to the printer driver which creates PostScript and Acrobat's driver plug-in passes that PostScript to Acrobat Distiller which converts PostScript to PDF which then saves the PDF and opens the PDF file in Acrobat), all layout decisions have been made. The factors involved include page size, unprintable page margins (Adobe PDF has no unprintable areas, real printers do - typically up to 0.25" on each edge of the page), and device resolution (Adobe PDF defaults to 1200dpi although you can change this in the Printer Setup).

By the way, similar “issues” occur when you create PDF from Excel using Acrobat's PDFMaker (Save as Adobe PDF - the preferred method of creating PDF from Excel) or even Microsoft's own “Save as PDF” (number of nasty bugs and can't handle OpenType CFF fonts).

          - Dov

- Dov Isaacs, former Adobe Principal Scientist (April 30, 1990 - May 30, 2021)

1 reply

Dov Isaacs
Dov IsaacsCorrect answer
Legend
Aug 21, 2017 7:28 PM UTC

The margins and a number of other issues associated with layout (including line breaks) are controlled strictly by Excel in conjunction with the print driver. By the time the conversion of PostScript to PDF occurs (when you print to Adobe PDF, Excel creates GDI which is passed to the printer driver which creates PostScript and Acrobat's driver plug-in passes that PostScript to Acrobat Distiller which converts PostScript to PDF which then saves the PDF and opens the PDF file in Acrobat), all layout decisions have been made. The factors involved include page size, unprintable page margins (Adobe PDF has no unprintable areas, real printers do - typically up to 0.25" on each edge of the page), and device resolution (Adobe PDF defaults to 1200dpi although you can change this in the Printer Setup).

By the way, similar “issues” occur when you create PDF from Excel using Acrobat's PDFMaker (Save as Adobe PDF - the preferred method of creating PDF from Excel) or even Microsoft's own “Save as PDF” (number of nasty bugs and can't handle OpenType CFF fonts).

          - Dov

Translate
- Dov Isaacs, former Adobe Principal Scientist (April 30, 1990 - May 30, 2021)