Why PDF Header and Footer Images Change Size in Excel
Question details
The user needs to understand and correct differences in the size of PDF-derived images used in Excel headers or footers across computers.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A PDF-derived image is used as a header or footer in a workbook opened on different computers.
- Observed behavior
- The image appears at 100% scale on one computer but much smaller on another, even though page-fit and aspect-ratio settings match.
Have the original PDF and the affected workbook available on both computers. Check the Excel versions and select the same printer and paper size where possible before comparing print previews.
Test the Header or Footer Image in a New Workbook
Use a new workbook and another computer to check whether the size difference is specific to one file or environment.
Excel version, operating system, printer driver, display settings, or PDF rendering may affect how an image is sized or displayed. Matching page-fit settings alone may not eliminate these differences.
In Excel, select File > New and create a blank workbook.
Select Insert > Header & Footer, click a header or footer section, and use Picture to insert the same source image. If Excel does not accept the PDF, export the same PDF page as a PNG and use that image on both computers.
Open the test workbook on each computer and select File > Print. Choose the same printer and paper size where available, then compare the header or footer in print preview.
Repeat the test with another image and workbook. If the difference occurs only in the original workbook, review that workbook's header or footer image settings; if it occurs more broadly, compare Excel versions and printer drivers.

Manually Adjust the Header or Footer Image Size
Use this workaround when the image is consistently too large or too small on a computer.
Work With Spreadsheet Headers and Footers in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format support for an easier move between applications. It does not repair Excel's image-rendering behavior, so check the layout after opening your workbook.

Frequently Asked Questions
Why does the same header image look different on two computers?
Excel versions, operating systems, printer drivers, display settings, and PDF rendering can affect the result. Test the same image in a new workbook and compare it using the same printer and paper size where possible.
Where can I resize a header or footer image in Excel?
Select Insert > Header & Footer, click the section containing the image, and choose Format Picture on the Header & Footer tab. Use the Size tab to adjust its dimensions or scale.
What should I do if Excel won't insert my PDF into a header?
Export the relevant PDF page as a PNG, then select Insert > Header & Footer and use Picture to insert the PNG. Use the same exported image when comparing computers.
Does matching the worksheet's fit-to-page setting guarantee the same header size?
No. Header and footer image settings and differences in the computer or printer environment can still affect the result. Check File > Print on each computer and adjust the image through Format Picture if necessary.




