How to Fix Excel Print Preview Changing an Image Header
Question details
The user needs to understand why an image inserted into an Excel header appears distorted, resized, or misplaced in Print Preview compared to the worksheet view, and how to resolve it.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Previewing a spreadsheet before printing to ensure the header image and page layout are correctly formatted.
- Observed behavior
- The header image looks different, shifted, or incorrectly scaled in Print Preview compared to its appearance in the standard editing view.
Before spending time adjusting header settings, try printing a test page to a physical printer or saving the file as a PDF, as Print Preview rendering can sometimes be inaccurate.
Verify the Output by Printing to PDF
Print Preview is often just an estimation based on printer drivers. Printing to a PDF helps determine if the issue is a rendering glitch in the preview or an actual formatting error.
Excel's Print Preview relies on your default printer's communication with the software. Sometimes, high-resolution images like PNGs render poorly in the preview but print perfectly fine. Bypassing the preview by generating a PDF gives you a true representation of the final document.
Go to the 'File' menu and select 'Print' in your Excel workbook.
Click the Printer dropdown menu and change the selected printer to 'Microsoft Print to PDF' or your preferred PDF creator.
Click the 'Print' button, choose a destination folder on your computer, and save the file.
Open the newly saved PDF document to verify if the header image appears correctly.

Reinsert and Format the Header Image
If the PDF or paper printout is also incorrect, the image's dimensions or scaling might be improperly configured in the Page Setup settings.
Seamlessly Add and Print Headers with WPS Spreadsheet
WPS Office provides a highly accurate Print Preview feature, ensuring what you see on the screen matches your final printed document or PDF. It handles image headers, footers, and page layouts intuitively without rendering glitches.
- 1. Open Your File: Open your existing workbook in WPS Spreadsheet.
- 2. Insert Your Header: Go to the 'Insert' tab and click 'Header and Footer' to easily add your logo or image.
- 3. Preview the Output: Use the 'Print Preview' button to view a high-fidelity, accurate representation of your final printed page.
- 4. Export to PDF: Click 'Export to PDF' directly from the toolbar to save a perfect digital copy.

Frequently Asked Questions
Why does Excel Print Preview look different from the normal view?
Print Preview renders the document based on your active printer's drivers and settings. If the printer driver handles graphics differently or has specific margin limitations, the preview might show slight shifts in image scaling or placement compared to the standard worksheet view.
What is the best image format to use for an Excel header?
PNG is generally the best format for header images because it supports lossless compression and transparent backgrounds. This prevents ugly white boxes from appearing around your logo when printed on colored backgrounds.
How do I stop my header image from overlapping with my spreadsheet data?
To prevent overlapping, you need to adjust your page margins. Go to Page Layout > Margins > Custom Margins, and increase the 'Top' margin so it is larger than the 'Header' margin. This gives the image enough space to sit above your data.
Can I resize an image after putting it in the header?
Yes. Click inside the header section, navigate to the Header & Footer tools design tab, and click 'Format Picture'. From the dialog box, you can precisely adjust the height, width, and scale percentage of your inserted image.




