How to Fix Excel Cropping Header Logos When Printing to PDF
Question details
The user needs to prevent a logo embedded in an Excel header from being cropped when converting the workbook to a PDF.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Generating a PDF from an Excel workbook containing a header logo.
- Observed behavior
- The header logo appears correctly in the Excel workbook but is cropped in the resulting PDF.
Ensure that the image file used for the header logo is properly scaled and fits well within the standard margin settings of your workbook before attempting to export.
Use the 'Export' or 'Save As' Feature Instead of Print to PDF
Using Excel's built-in Export or Save As functionality bypasses the virtual printer limitations that often cause header cropping.
The 'Print to PDF' virtual printer sometimes applies physical margin constraints that inadvertently cut off headers or footers. Using the native 'Save As' function processes the document layout directly, preserving embedded images accurately.
Click on the 'File' tab in the top left corner of Excel and select 'Save As' or 'Save a Copy'.
Choose your destination folder, click the 'Save as type' drop-down menu, and select 'PDF (*.pdf)' from the list of available formats.
Click the 'Options' button to verify you are saving the active sheets or the entire workbook as needed, then click 'Save' to generate the PDF with an intact header logo.

Adjust Header Margins and Logo Size
Modifying the page setup settings ensures the logo fits within the printable area, preventing it from being cut off during PDF conversion.
Use WPS Spreadsheet to Export PDFs Without Cropping
WPS Office provides a highly optimized built-in PDF converter that perfectly preserves headers, footers, and embedded logos from your spreadsheets. Enjoy flawless layout retention and format compatibility without relying on problematic virtual printers.
- 1. Open your spreadsheet in WPS: Launch WPS Office and open your .xlsx or .xls file containing the header logo.
- 2. Access the Export to PDF tool: Click on the 'Menu' button in the top left corner, then select 'Export to PDF'.
- 3. Configure export settings: In the dialog box, verify the pages to export and ensure the layout looks correct in the preview.
- 4. Generate the PDF: Click 'Export to PDF' and choose your save location. Your PDF will be created with the header logo perfectly preserved.

Frequently Asked Questions
Why does Print to PDF crop my header logo in Excel?
The 'Print to PDF' function relies on a virtual printer driver which applies its own unprintable margin limitations. If the header logo extends into this unprintable area defined by the virtual printer, it gets cropped.
Does image resolution affect how logos are printed to PDF?
Yes, inserting a very high-resolution image into the header can sometimes cause scaling or rendering issues during PDF conversion. Resizing the image to the exact dimensions you need before inserting it into the spreadsheet often yields better results.
Can I edit the cropped header directly in the PDF?
Once the PDF is generated using the Print to PDF method, the cropped image data is permanently lost in that output file. You must fix the margins or use the 'Save As PDF' method in your spreadsheet software and regenerate the PDF file to restore the full logo.




