Formatting Issues

Fix Excel Headers and Footers Changing Size on Different Computers

Muhammad TalhaMuhammad Talha Nov 11, 2026 870 views

Question details

The user needs to maintain consistent header and footer formatting in a shared Microsoft 365 workbook when opened on multiple computers or exported to PDF.

How to Fix Excel Headers and Footers Changing Size on Different Computers
Product
Microsoft Excel
Device & OS
not provided
Scenario
Opening a shared Excel workbook on multiple machines, printing, or exporting the file to PDF.
Observed behavior
Headers and footers display or print at varying sizes across different computers due to differing printer drivers, display settings, scaling configurations, or missing fonts.
Before you start

Before proceeding, verify that both computers have the same display scaling settings applied in Windows and ensure that the fonts used in your headers and footers are installed on all devices.

Solution 1Recommended

Synchronize Default Printer and Page Scaling Settings

Excel relies on the active printer driver to render page layouts, including headers and footers. Ensuring the same default printer and explicit scaling settings across devices prevents unauthorized resizing.

Microsoft Excel formats its page layout dynamically based on the specifications of your default printer. If one computer uses a physical office printer and another uses a different model, the margins, printable areas, and resulting header sizes will shift. Standardizing these settings forces Excel to render the document consistently.

1
Set a uniform default printer

On both computers, navigate to the Windows Control Panel, select 'Devices and Printers', and right-click to set the exact same printer model as the default. If a shared physical printer is not available, set 'Microsoft Print to PDF' as the default on both machines.

2
Verify Page Setup margins

Open your workbook in Excel, navigate to the 'Page Layout' tab, and click the dialog launcher arrow in the bottom right corner of the 'Page Setup' group. Ensure that the 'Paper size' and 'Margins' are identical across all devices.

3
Lock document scaling explicitly

In the same Page Setup window under the 'Page' tab, avoid leaving the scaling at an arbitrary percentage. Instead, select 'Fit to 1 page(s) wide by 1 tall' (or set it explicitly to 100% normal size) before saving or exporting to PDF.

4
Align header scaling options

Click the 'Header/Footer' tab inside the Page Setup dialog. Make sure 'Scale with document' and 'Align with page margins' are checked, as this binds the header size to your overall scaling rules.

Synchronize Default Printer and Page Scaling Settings
Tip for PDF Exports: If your primary goal is generating a PDF, setting 'Microsoft Print to PDF' as your default printer before adjusting layout settings will guarantee the highest accuracy between on-screen display and the final export.
Free Microsoft Office alternative

Maintain Consistent Spreadsheets with WPS Office

If you are tired of struggling with Microsoft Excel's printer-dependent rendering shifts, WPS Spreadsheet offers a highly compatible and stable alternative. It renders your page layouts, headers, and footers reliably across different computers without the hassle of tweaking drivers.

  1. 1. Download and Install: Get the free WPS Office suite from the official website and install it on your computer.
  2. 2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx workbook. Your headers, footers, and complex formatting will be preserved seamlessly.
  3. 3. Export to PDF Safely: Use the integrated 'Export to PDF' feature under the 'Menu' tab to securely save your document with stable, locked-in formatting.
Consistent layout and print rendering across different devices and operating systems.Seamless format compatibility with Microsoft Excel (.xlsx, .xls) files.Built-in, highly accurate PDF export tools that preserve your exact header and footer sizes.Lightweight software footprint with a familiar, easy-to-use interface.
QA img-9

Frequently Asked Questions

Why do Excel headers look perfectly fine on my screen but change size when printed or exported?

Excel optimizes the on-screen view using your display driver, but it relies entirely on your default printer driver to calculate printed margins, DPI, and PDF exports. If the printer driver communicates a slightly different printable area, Excel recalculates the layout, causing headers and footers to shift.

Can Windows display scaling settings affect Excel's header and footer size?

Yes. If one computer uses 100% display scaling and another uses 125% or 150% (commonly found on high-resolution laptops), Excel might render the page layout differently. Ensure both computers use standard scaling in Windows Display Settings to minimize discrepancies.

Is there a way to permanently lock the header formatting in a shared Microsoft 365 workbook?

You cannot completely lock how different local printer drivers process the file. However, you can mitigate changes by using standard fonts (like Calibri or Arial), checking the 'Scale with document' option in the Header & Footer settings, and agreeing to use a universal virtual printer like 'Microsoft Print to PDF' across your team.