Formatting Issues

Why PDF Header and Footer Images Change Size in Excel

Olivia MillerOlivia Miller Nov 22, 2026 868 views

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.

Why PDF Header and Footer Images Change Size in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a test workbook

In Excel, select File > New and create a blank workbook.

2
Insert the same image

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.

3
Compare print previews

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.

4
Check other files

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.

Test the Header or Footer Image in a New Workbook
Free Microsoft Office alternative

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.

Use spreadsheet headers and footers for page brandingOpen and edit Microsoft Excel XLSX filesWork in a familiar, easy-to-use interfaceMove existing Office files to a lightweight alternative
microsoft office alternative - wps office

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.