Fix Excel Headers and Footers Changing Size on Different Computers
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.

- 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 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.
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.
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.
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.
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.
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.

Install Missing Fonts on Target Computers
Missing custom fonts will cause Excel to silently substitute a different font, which drastically changes the layout, spacing, and sizing of your headers and footers.
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. Download and Install: Get the free WPS Office suite from the official website and install it on your computer.
- 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. 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.

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.




